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?