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?