cell formatting

  • Thread starter Thread starter owl527
  • Start date Start date
O

owl527

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
 
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,
I tried using the above method but it doesn't work. I do not see any
changes.
Please help again. Thanks.
 
Hi Owl,

It works for me, perhaps I can tell you what is the problem if you send me a
sample workbook! Address: (e-mail address removed)

Regards,
Stefi


„owl527†ezt írta:
 
What if I want to highlight the 5 highest numbers in each line (and I
have 30 lines)? Can this be done?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Excel JUMP FROM SEARCH BAR TO RESULT 3
Highlight Highest number 8
Excel Highlighting duplicates 0
Conditional Formatting in Excel 2007 2
Number Of Cells Between Colored Cells? 1
Code to identify whether a cell has manual highlighting or not 5
Automatic Color on Export to Excel 2

Back
Top