| Home |
| Search |
| Today's Posts |
|
#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. |
| 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 | |||
Threaded Mode
