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

I realised I hadn't included the $ sign in front of the formulas, but had taken them out completely.

Having re-inserted them this is what I get now.  Still not quite right.

Answer 3

You're a star!  Thank you for the clarification, that works wonderful!

Answer 4

You're a star!  Not at all. Always easy when you know

Thank you for the clarification You're welcome

that works wonderful! Good news. Glad we could help & Thanks for posting back