Miles GoodchildMar 9, 20222 minUsing VLOOKUP on multiple items and how to split text stringsHow to apply VLOOKUP to many cells and add the results. How to split text cells into columns
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...