Conditional Formatting of maximum value in each row of many

excel max excel-2013 conditional-formatting rule
Eastern Computers picture Eastern Computers · Nov 27, 2015 · Viewed 13.8k times · Source

I have a spreadsheet with 250+ rows of data and need to find the largest value in each row. I tried to use Conditional Formatting, however I need the same rule for each row so can't highlight all the data, and trying to copy and paste it would be too cumbersome.

Is there a faster way of applying the same rule to each row separately?

Answer

pnuts picture pnuts · Nov 27, 2015

Please select he relevant columns (say A:H) and HOME > Styles - Conditional Formatting, New Rule..., Use a formula to determine which cells to format and Format values where this formula is true:: 

=A1=MAX($A1:$H1)

Format..., select your choice of formatting, OK, OK.

If you want the formatting to stop when there are no values in the row adjust to: 

 =AND(COUNT($A1:$H1)<>0,A1=MAX($A1:$H1))

Related questions

Excel CSV. file with more than 1,048,576 rows of data

I have been given a CSV file with more than the MAX Excel can handle, and I really need to be able to see all the data. I understand and have tried the method of "splitting" it, but it doesnt …

Read More
Return Max Value of range that is determined by an Index & Match lookup

I need a cell to display the max value of a range who's row is defined by an index and match formula. I know this will be an array function but I'm struggling to get the syntax right. Here is …

Read More
find max or min in excel, with conditions

In my spreadsheet I have a column with negative and positive values. I need to get the minimum among all positive values and the maximum among all negative ones. How can I do so?

Read More