How to Highlight The Highest and Lowest Value in Each Row or Column in Excel

This post will guide you how to highlight the highest value in each row or column in Excel. How do I highlight the lowest value in each row and column with conditional formatting function.

Highlight Highest Value in Each Row


Assuming that you have a list of data in range A1:D7, and you want to highlight all highest values in each row or highlight all lowest values in each row. How to achieve it. You need to use the conditional formatting feature to achieve the result. Just do the following steps:

#1 select the range of cells that you want to highlight the highest values in each row.

highlight highest value in row1

#2 go to HOME tab, click Conditional Formatting command under Styles group. And then select New Rule from the drop down menu list. And the New Formatting Rule dialog will appear.

highlight highest value in row2

#3 select Use a formula to determine which cells to format in the Select a Rule Type list box, and type the following formula in the Format values where this formula is true text box. And then click Format button.

=B2=MAX($B2:$D2)

highlight highest value in row3

#4 switch to Fill tab, select on background color as you need. Click Ok button.

highlight highest value in row4

#5 click Ok button. The highest value in each row has been highlighted.

highlight highest value in row5

Highlight Lowest Value in Each Row


If you want to highlight lowest value in each row in your table, you just need to repeat the above steps, just use the following formula instead of it.

=B2=MIN($B2:$D2)

highlight highest value in row10

highlight highest value in row11

Highlight Highest Value in Each Column


If you want to highlight highest value in one column, you can repeat the above steps, and then use the following formula:

=B2=MAX($B$2:B$7)

highlight highest value in row6

highlight highest value in row7

Highlight Lowest Value in Each Column


If you want to highlight highest value in one column, you can repeat the above steps, and then use the following formula:

=B2=MIN(B$2:B$7)

highlight highest value in row8

highlight highest value in row9

Video: Highlight Highest and Lowest Values in each Row or Column

Related Functions


    • Excel MIN function
      The Excel MIN function returns the smallest numeric value from the numbers that you provided. Or returns the smallest value in the array.The MIN function is a build-in function in Microsoft Excel and it is categorized as a Statistical Function.The syntax of the MIN function is as below:= MIN(num1,[num2,…numn])….
    • Excel MAX function
      The Excel MAX function returns the largest numeric value from the numbers that you provided. Or returns the largest value in the array.= MAX(num1,[num2,…numn])…

You might also like:

Comments

So empty here ... leave a comment!

Leave a Reply

Your email address will not be published. Required fields are marked *

Sidebar