Search code examples
excelmaxexcel-2013conditional-formattingrule

Conditional Formatting of maximum value in each row of many

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?

Solution

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