Select A1, then Format ConditionalFormatting
Set Condition 1 to Formula is.......=A1=LARGE(a:a,5), and set font to bold
blue and get out

Then select A1 and click on the FormatPainterBrush in the tool bar and
sleect A2 and drag it down column A as far as you wish........

hth
Vaya con Dios,
Chuck, CABGx3


"Zubbus" wrote:


Hi!

Is there a way (even a long way) to apply conditional formatting based
on order, say:

I want to paint bold blue the 5 highest values in a row?

Thanks.


--
Zubbus
------------------------------------------------------------------------
Zubbus's Profile: http://www.excelforum.com/member.php...o&userid=29875
View this thread: http://www.excelforum.com/showthread...hreadid=495792