Hi guys,

I need to do this,

I have 3 colums and multipul rows, for this example I will use 3 colums & 20 rows.

There are numbers is all cells. I will give a bit of an example to help understand my desired outcome.

1st column has a row of numbers from 1 - 10 in random
2nd column has a row of numbers from 1 - 10 in random
3rd column has a row of numbers from 1 - 10 in random

If any of the 20 rows has the highest value in all 3 rows (or matching)

eg;

row1 has 3 - 3 - 2
row2 has 3 - 3 - 1
row3 has 2 - 1 - 1

So row1 has the highest values in all 3 colums, 2 match and thats ok.

I want that row to then get backfilled with a color - eg;red

If however, none of the rows have the highest in all three colums, then I want it NOT to backfill the color....

So in other words I am pasting in data and I want a specific row to stand out if it meets a certian creiteria..being the highest of all three columns

Any idea's?

Cheers,
Nick.