In this article, we will learn how to highlight value in a range that are above average or below average, using conditional formatting of course.
To do so, one way is to find average of those numbers and then compare each value to highlight. But we don’t need to do that hustle. Excel Conditional Formatting has two presets for average comparisons.
These options are found at Home? Conditional Formatting? Top Bottom Rule.
Let’s have an quick example to understand how to use it.
Example: Highlight Age Above Average and Below Average using Excel Conditional Formatting
Here, I have some random data of some people on earth with their age. I want highlight all value that are greater than the average age with Red fill and Below Average age with Green Fill.
Now select the age range and follow these steps.
Now we have all values that are above average highlighted. Next we do it for below average.
And it is done. We have our above average and below average values highlighted.
You can check it if you want by calculating the average.
So yeah guys, this how you can highlight above and below average values in a set of calculable values. If you have any doubts or any specific requirement of conditional formatting, ask it in the comments section below.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.