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.

#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.

#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)

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

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

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 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 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)

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])…