How To Highlight Cells With Value Greater Than Average Value Of The Column In Excel

Let’s see how we could highlight the cells having value greater than the average value of that column in excel.

We have the data as shown below and we would like to highlight the cells which are having values more than the average of our data in column A.

We will use a simple conditional formatting feature in excel to get the desired result.


Step 1

Select the data and go to Conditional Formatting -> Highlight Cell Rules->Greater Than in home tab as shown below.


Step 2

In the box write the average formula as shown below to highlight the values greater than the average value of the selected data.


And press OK

Step 3

As you could see the values greater than average are highlighted in red. You could extend the range of the data in the formula by editing it and could select different colors as well to highlight from the box appeared in previous step.


Hope this helped.

Share The Knowledge

Random Posts

Leave a Reply