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?