| Home |
| Search |
| Today's Posts |
|
#7
|
|||
|
|||
Hey thanks, worked great!!!
"N Harkawat" wrote: Easiest solution I guess would be to get the 3 largest values in a sepaprate area in worksheet and do conditional formatting by referenceing to it say you insert these 3 largest values in Z1,z2 and z3 (assuming that your data is in a1:a1000) For largest on cell Z1 type =Max(a1:a1000) On Z2 (2nd largest ) =max(if(a1:a1000<z1,a1:a1000)) array entered (ctrl+shift+enter) On Z3 (for 3rd largest) =max(if(a1:a1000<z2,a1:a1000)) array entered (ctrl+shift+enter) "John" wrote in message ... Duplicate numbers should all have the same format, ie all the highest #'s are red, the second highest #'s are all blue, etc... "Ron Rosenfeld" wrote: On Wed, 11 May 2005 20:53:02 -0700, "John" wrote: I'd like to highlight the 3 highest numbers in a column - a different color for each high number. I figured I'd use conditional formatting and LARGE, but there are duplicate numbers, which should all be highlighted. Also is there a limit on the length of a formula? Thanks!!!! What do you want to happen in the event of duplicate numbers? --ron |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
| Need conditional formatting formula to highlight top ten values i. | Excel Worksheet Functions | |||
| Values w/conditional formatting | Excel Worksheet Functions | |||
| Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
| Formatting cells in Excel for certain Values to appear certain Col | Excel Worksheet Functions | |||
Threaded Mode
