Conditional Format....IF

W

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?????
 
C

CLR

Maybe the LARGE function would work as your Conditional Format formula

Vaya con Dios,
Chuck, CABGx3
 
F

Frank Kabel

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

as formulas in the conditional format dialog
 
Top