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

i would like to know how to highlight the ten highest numbers in a range
without doing it manually.

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

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

"Help Wanted" wrote:

i would like to know how to highlight the ten highest numbers in a range
without doing it manually.

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

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 FormatConditional 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 tabStylesConditional FormattingTop/Bottom RulesTop 10 Items
Fill in the info, select a format
OK out


--
Biff
Microsoft Excel MVP


"Help Wanted" <Help wrote in message
...
i would like to know how to highlight the ten highest numbers in a range
without doing it manually.

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

Clarification

(but it will also work in Excel 2007)

The formula will work but the menu path is different!

Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a
formula to determine which cells to format

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

--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
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 FormatConditional 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 tabStylesConditional FormattingTop/Bottom RulesTop 10 Items
Fill in the info, select a format
OK out


--
Biff
Microsoft Excel MVP


"Help Wanted" <Help wrote in message
...
i would like to know how to highlight the ten highest numbers in a range
without doing it manually.