How do I use traffic lights in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Format>Conditional Formatting>Cell Value is:

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

Gord Dibben Excel MVP
 
Another method might be to use a wingding character that is solid round, say
char(197) and use conditional formatting and color the character red, amber
or green for each of your numbers. Set conditional formatting to "formula
is" and set the reference to your cell with the condition (<=10,f or
instance) and then set the font to red. Adjust as needed.
Gary
 
this can be pretty complicated. Its best if someone can
show you this in person. Is there anyone where you work
who can show you how to use conditional formating?
 
Hi Jose,

Jose said:
this can be pretty complicated. Its best if someone can
show you this in person. Is there anyone where you work
who can show you how to use conditional formating?
Click to expand...

That person would be hard pushed to better Debra Dalgleish's excellent
tutorial - see Debra's earlier response for the link.

Visit also the following link to Debra's site for a wealth of other
material:

http://www.contextures.com/tiptech.html
 
Back
Top