Use Format/Conditional formatting!

Select your column, say E, and fill the format conditions dialog box like
this:

Cell value Greater then =LARGE(E:E,6)

and choose a format (say color)

Regards,
Stefi

€žowl527€� ezt Ã*rta:


Hi,

if I have a column of numbers and I want to the top 5 highest number to
be highlighted automatically. Is there a way to do it automatically?
i.e. identify the cell and highlight it automatically. Please let me
know. Thanks.


--
owl527
------------------------------------------------------------------------
owl527's Profile: http://www.excelforum.com/member.php...o&userid=20916
View this thread: http://www.excelforum.com/showthread...hreadid=498630