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 GoodchildDec 5, 20212 minAn easy way to make fully dynamic related drop-down boxesIn previous blog posts, we have seen how to make drop-down boxes driven by the entries in other cells and drop-down boxes. In this blog,...