conditional format based on rank?

  • Thread starter Thread starter J.W. Aldridge
  • Start date Start date
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
 
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
 
Back
Top