Auto Color
 

i want to enter the letter G into the cell, and the cell should automatically
change to the color green. i want to enter the letter P into the cell, and
the cell should automatically change to the color yellow. i want to enter
the letter R into the cell, and the cell should automatically change to the
color red.

how do i do that?

Auto Color
 

Check the "Help" after "Conditional Format"
Micky


"confusedguy" wrote:

i want to enter the letter G into the cell, and the cell should automatically
change to the color green. i want to enter the letter P into the cell, and
the cell should automatically change to the color yellow. i want to enter
the letter R into the cell, and the cell should automatically change to the
color red.

how do i do that?

Auto Color
 

Hi
This site will explain it much better then typing it here.
HTH
John
http://www.contextures.com/xlCondFormat01.html
"confusedguy" wrote in message
...
i want to enter the letter G into the cell, and the cell should automatically
change to the color green. i want to enter the letter P into the cell, and
the cell should automatically change to the color yellow. i want to enter
the letter R into the cell, and the cell should automatically change to the
color red.

how do i do that?