conditional formatting

Originally Posted by xceed

I now want to conditionally format these 3...
The problem with using the standard selection of largest is that if the 4th highest is the same as the third, 4 are highlighted (1st row in attached).

Highlight A2:I17 (selecting from A2 first)

Delete your existing rules

Choose to "Use a Formula" for your Conditional Format and insert the below:

=IF(ISNUMBER(A2),A2+1-COLUMN(A2)/100000>=LARGE(INDEX($A2:$I2+1-COLUMN($A2:$I2)/100000,0),3))
set format as appropriate

Click OK etc...


Note: the use of the embedded INDEX in the above formula is pretty much a necessity if you're using XL2007 as implied (unless you wish to created Named Ranges) - this is not necessary in other versions
(in other words it is used to circumvent a bug in XL2007)