If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
paint cells with highest numbers
How do I get excel to paint the cells with say the 14
highest numbers i a defined area of the sheet? |
#2
|
|||
|
|||
paint cells with highest numbers
Assuming your range (called "rng") is say, A1:A20, then
select the range, go to Format Conditional Formatting, Formula Is, and put: =SUM(--($A1=LARGE(rng,ROW(INDIRECT("1:14"))))) Press the "Format" button and format as desired. HTH Jason Atlanta, GA -----Original Message----- How do I get excel to paint the cells with say the 14 highest numbers i a defined area of the sheet? . |
#3
|
|||
|
|||
paint cells with highest numbers
Hi
lets say your area is A1:G30 try the following - select this area - goto Format - Conditional format - enter the following formula =A1=LARGE($A$1:$G$30,14) -- Regards Frank Kabel Frankfurt, Germany schrieb im Newsbeitrag ... How do I get excel to paint the cells with say the 14 highest numbers i a defined area of the sheet? |
Thread Tools | |
Display Modes | |
|
|