0 of 135 lessons complete (0%)
Conditional Formatting

Conditional Format Examples

You don’t have access to this lesson
Please purchase this course, or sign in if you’re already enrolled, to access the course content.

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.