Conditional formatting independently for multiple rows

Question

Hello,

I have already googled for the answer but cannot find exactly what I need.

I have an excel spreadsheet with 4 columns with different numbers in each cell.

There are about 450 rows to the table.

For each row, I would like to apply the 2-colour scale conditional format to show which values are highest and which are lowest (and which come in between).

I then want to apply this format to all other rows.

The issue I have had is I can only get it to format a colour scale for the spreadsheet as a whole, rather than independently colour scale for each row.

Does anyone have any suggestions how to independently colour scale each row?

Thanks in advance.

Answer 1

Hi,

You want the largest1, largest2... per Row. So, from your last picture formula must be:

=C13=LARGE($C13:$F13,4)

Same goes for the other rules

=C13=LARGE($C13:$F13,3)

=C13=LARGE($C13:$F13,2)

=C13=LARGE($C13:$F13,1)

Answer 2

The formula should be

=C13=LARGE($C13:$F13,4)

i.e. referring to the same row only, without $ signs before the row numbers.

Answer 3

Thanks Hans

Answer 4

@ap93g

When all OK would you mind Making as Answer the option you implemented? Could help others with same/similar scenario… Thanks

Answer 5

Thanks HansV MVP.

I'm still not getting this to work for some reason.  Can you identify what I'm doing incorrectly?