conditional format according to rank?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

J.W. Aldridge - 25 Oct 2007 00:32 GMT

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

Reply to this Message

Bernie Deitrick - 25 Oct 2007 19:17 GMT

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

> 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

Reply to this Message

J.W. Aldridge - 26 Oct 2007 18:28 GMT

worked purrfectly!

thanx

Reply to this Message

Rate this thread: