how do i highlight the ten highest numbers in a range?

  • Thread starter Thread starter Help Wanted
  • Start date Start date
H

Help Wanted

i would like to know how to highlight the ten highest numbers in a range
without doing it manually.
 
Let's say your range is from A1:A14 and you start selecting the range in A1.
Go to Conditional format and enter something like this for the formula.


=$A1>=LARGE($A$1:$A$14,10)

Set the format as desired.

HTH,
Barb Reinhardt
 
What version of Excel are you using?

Use conditional formatting

Assume the range of numbers is A1:A20

For Excel versions prior to Excel 2007 (but it will also work in Excel
2007):

Select the range of cells, A1:A20
Goto the menu Format>Conditional Formatting
Select the Formula Is option
Enter this formula in the box on the right:
=A1>=LARGE(A$1:A$20,10)
Click the Format button
Select the desired style(s)
OK out

For Excel 2007

Select the range of cells, A1:A20
Goto Home tab>Styles>Conditional Formatting>Top/Bottom Rules>Top 10 Items
Fill in the info, select a format
OK out
 
Clarification
(but it will also work in Excel 2007)
Click to expand...

The formula will work but the menu path is different!

Goto Home tab>Styles>Conditional Formatting>Manage rules>New rule>Use a
formula to determine which cells to format

But, why use this option when you can use the Top/Bottom Rules option.
 
Back
Top