Hi,

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

--
owl52
-----------------------------------------------------------------------
owl527's Profile: http://www.excelforum.com/member.php...fo&userid=2091
View this thread: http://www.excelforum.com/showthread.php?threadid=49863

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

Hi,
I tried using the above method but it doesn't work. I do not see any
changes.
Please help again. Thanks.


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

Hi Owl,

It works for me, perhaps I can tell you what is the problem if you send me a
sample workbook! Address:

Regards,
Stefi


€žowl527€� ezt Ã*rta:


Hi,
I tried using the above method but it doesn't work. I do not see any
changes.
Please help again. Thanks.


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

it works now!!! thank you very much! =)


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

What if I want to highlight the 5 highest numbers in each line (and I
have 30 lines)? Can this be done?


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