Conditional Format....IF

[wayne]

have a RANK formula to look at a list of numbers and
return its position. (league Table)

These cells have a conditional format attached where the
cell ranked first (1) is filled yellow (Gold?).

My problem is I want to colour the cell gray (silver) if
the cell is second (2) and bronze for third.

Any ideas on how this would be done?????

 

[CLR]

Maybe the LARGE function would work as your Conditional Format formula

Vaya con Dios,
Chuck, CABGx3

 

[Frank Kabel]

Hi
use
=cell_reference=LARGE(range,2)
and
=cell_reference=LARGE(range,3)

as formulas in the conditional format dialog