4. Conditional Formatting: Values

Conditional formatting highlights cells on its own: when the data changes, the highlighting changes with it.

• Greater Than / Less Than / Between / Equal To — compare with a number (in Excel: Home › Conditional Formatting › Highlight Cells Rules);
• Top 10 Items / Bottom 10 Items — the best or the worst values (in Excel: Home › Conditional Formatting › Top/Bottom Rules). The trainer shortens this to Top N, where you enter any number of items.

Select a range, click Conditional Formatting, choose a rule and a color. A sheet can have as many rules as you like. The trainer lists the rules directly instead of in submenus.