0 of 135 lessons complete (0%)
Conditional Formatting

Highlight all above average cells

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.

This lesson highlights the useful wizards available to run with Conditional Format e.g. In the Top and Bottom section you can ask Excel to highlight cells that are above/ below average or top/ bottom 10.

As shown below, in the Top/ Bottom Rules there are a number of other options which are useful. Below we want to highlight the cells in B16 to F16 that are Above Average.

Highlight all above average cells

So below, if the numbers  change, Excel will recalculate the average and adjust the colours to only highlight the cells above average.

Highlight all above average cells

To see the full course contents click here.