Conditional Formatting

A cell format applied by a rule, either by value (for example salary under 5000) or by a formula such as =$E2=$E$204. Formula rules use Absolute Reference and mixed references so the test slides correctly over the range. Also in Lec 03, Lec 05.

When to use

It colours the employee table, which lets the class sort and filter by colour, and it hides the overflow days in the calendar grids, for example with =K7>DAY($O$2) and a white font. Forgetting the $ on the column makes a rule drift sideways and colour the wrong cells.

See Lec 01.

Appears in

No references yet.