How do you get traffic lighting to work in Excel 2003

[Guest]

I am trying to assign a color code to a set of number 1=Green, 2=Yellow,
3=Orange and 4=Red. When the number 4 shows up in the cell, I want the cell
to turn red or Green if a 1 is entered. How can this be accomplished?

 

[Bernard Liengme]

Use Format |Conditional Formatting
after you have experimented, come back with questions
best wishes

 

[Chip Pearson]

You can do this (almost) with Conditional Formatting from the
Format menu. However, you are limited to 3 conditions, so you'd
have to make the default color of the cell Green (or one of the
other colors).


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


message
news:[email protected]...

 

[gjcase]

Ref Chip's reply:

You can get a 4th color by formatting negative numbers to be a
different color than default black (usually red). This works in
addition to the conditional formatting. This does require that your
values include one negative number. This just changes the text,
though, not the cell background.

---Glenn