Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Highest total of any three consecutive numbers in a range. | Excel Worksheet Functions | |||
Highest 5 numbers in a range turn red | Excel Discussion (Misc queries) | |||
Highlight highest / lowest number in a row | Excel Discussion (Misc queries) | |||
highlight highest and lowest cells within a given column in ex | New Users to Excel | |||
How do I add only the highest three numbers in a range of data? | Excel Worksheet Functions |