Shorty

FormatConditional FormattingCell Value is:

Note: you can add up to 3 conditions(4 if you count default)

Gord Dibben Excel MVP

On Wed, 22 Dec 2004 16:35:03 -0800, Shorty
wrote:

I am wanting to use traffic lights in excel that change colour based on the
result of a variance cell, ie if the result of the cell is 10 make the
traffic light green, if it is 20 make the traffic light amber, if the result
is 30 make the traffic light red. How do I do this?