Conditional Format Examples
Conditional Format Ex 1
As per the instructions on the spreadsheet:
- Row 14
- Use colours- Red <=10%, Yellow >10% but <20%, Green >20%
- Row 18
- Highlight the above average cells
Conditional Format Ex 2
Use Data bars to show the relative size of each cell for weekdays
Use Data bars to show the relative size of each cell for weekends
Use Colour Scales to show the relative size for each cell for the grand Total
Conditional Format Ex 3
In c15 to G21 use colour scales to show which number is the lowest (green) and the highest (red) going through yellow.
To see the full course contents click here.