Conditional formatting

So far we’ve been busy making sure you’ve got an Excel modelling survival toolkit. In that toolkit we’ve placed the insert function feature (“Shift” “F3”), Excel help (“F1”), the If formula, the Vlookup formula and goal seek.

Now on the Excel formulas course we start to get into functionality that is neat but that you’ll perhaps use slightly less regularly.

In the next course lesson we look at “conditional formatting”. Do you remember the traffic light system we set up when we looked at the If formula? Today we’re going to add real colours to that – and that’s what conditional formatting can help us with.

We’ll help you navigate some of the apparent complexity you meet when you first tackle conditional formatting.

You’ll find that you can use conditional formatting to highlight particular cell results and that you can layer in multiple conditional formats (red, green, amber).

We also leave you with some good practice guidelines on conditional formatting.