Conditional formatting allows you to automatically get Excel to change the appearance of some cells based on their values. This is particularly useful if you need something to stand out so that as you scan the worksheet you are quickly drawn to what you are looking for. Here in part 1 I get you started with highlight cells rules, data bars, color scales, icon sets and top-bottom rules. You will also see how to clear a rule.

In part 2 we take a look at how to manage rules and how to customise the formatting of a conditional format. You can also delete and manage rules, change icons in an icon set and see more conditions.

Conditional Formatting Part 1

Conditional Formatting Part 2