How to use Custom Formats to change the colour of the cell, display an emoji or add text depending on the cell's contents.

Whilst you can use conditional formatting and cell fill etc. to give you almost any colour in excel there is a "special" set of 56...

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...

In 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,...