conditional format according to rank?

[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

 

[Bernie Deitrick]

JW,

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

=D4=LARGE(D,1)
=D4=LARGE(D,2)
=D4=LARGE(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

 

[J.W. Aldridge]

worked purrfectly!

thanx