Conditional Format Examples

Please purchase the course before starting the lesson.

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.

 

Back to: Intermediate Excel Course > Conditional Formatting