conditional format based on rank?

J

J.W. Aldridge

is there any way to use a conditional format formula to rank the
numbers in column of a pivot table or a range?

example:

top score : cell pattern red
2nd highest: cell pattern blue
3rd highest: cell pattern yellow
 
R

Rick Rothstein \(MVP - VB\)

is there any way to use a conditional format formula to rank the
numbers in column of a pivot table or a range?

example:

top score : cell pattern red
2nd highest: cell pattern blue
3rd highest: cell pattern yellow
Click to expand...

Use these 3 Conditional Format formulas...

Condition 1
==========
Formula is: =C1=LARGE(C:C,1)
Format: Pattern -- Red

Condition 2
==========
Formula is: =C1=LARGE(C:C,2)
Format: Pattern -- Blue

Condition 1
==========
Formula is: =C1=LARGE(C:C,3)
Format: Pattern -- Yellow

Rick
 

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

conditional format according to rank? 2
Conditional format question 4
2nd condition in a conditional formatting not working 9
Automatically change the text format the cell when use a specific text 10
Conditional Formatting 1
Conditional Formatting: Data Bar, change gradient color based oncondition? 1
Conditional formatting based on formula cell 6
Conditional Format based on value in other cell 4

Top