G Guest May 26, 2004 #1 How do I get excel to paint the cells with say the 14 highest numbers i a defined area of the sheet?
J Jason Morin May 26, 2004 #2 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
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
F Frank Kabel May 26, 2004 #3 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)
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)
