How do you get traffic lighting to work in Excel 2003
 

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?

How do you get traffic lighting to work in Excel 2003
 

Use Format |Conditional Formatting
after you have experimented, come back with questions
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"jretherford" wrote in message
...
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?

How do you get traffic lighting to work in Excel 2003
 

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


"jretherford" wrote in
message
...
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?

How do you get traffic lighting to work in Excel 2003
 

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


--
gjcase
------------------------------------------------------------------------
gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=507781