paint cells with highest numbers

G

Guest

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

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

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

highlight the highest cell in a column 1
Highlight Highest Amount 2
Finding location (or start cell) of highest consecutive values 3
Get highest value and adjacent cell value 12
Return a High Number 6
Trying to find additional ranges outside of min, max, and average 2
Reference the 2nd and 3rd highest in range. 2
The best of 5 cells 3

Top