conditional format according to rank?

  • Thread starter Thread starter J.W. Aldridge
  • Start date Start date
J

J.W. Aldridge

Is there any way to rank the cells in a pivot table and have the cells
that rank 1,2, 3 highlight.
example:

if cell ranks, 1 = red, 2 = blue, 3 = yellow
 
JW,

Select the cells that you want highlighted, and use Format / C.Formatting.. Formula is, and
formulas like

=D4=LARGE(D:D,1)
=D4=LARGE(D:D,2)
=D4=LARGE(D:D,3)

Where D4 is the activecell at the time, and the numbers are in column D.

Set the shading as you want, for each case.

This assumes that the Largest number ranks as 1. If it is the converse, use SMALL instead of LARGE.

HTH,
Bernie
MS Excel MVP
 
Back
Top