Miles GoodchildFeb 15, 20221 minUse Excel custom formats to show emoji and textHow to use Custom Formats to change the colour of the cell, display an emoji or add text depending on the cell's contents.
Miles GoodchildFeb 15, 20222 minThe 56 standard colours in Excel - the ColorIndex values or palletWhilst you can use conditional formatting and cell fill etc. to give you almost any colour in excel there is a "special" set of 56...
Miles GoodchildDec 6, 20211 minHow to display a cell’s colour in Excel It is not possible to directly access the colour of a cell in an Excel worksheet. Thus you can not write an expression such as “if the...
Miles GoodchildNov 9, 20212 minExcel – how to make a drop-down dependent on another drop-downSometimes in Excel you want to make a selection dependent on another choice. For instance, you would like to select a country from a...