Auto Color

[confusedguy]

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?

 

[מיכ×ל (מיקי) ×בידן]

Check the "Help" after "Conditional Format"
Micky

 

[John]

Hi
This site will explain it much better then typing it here.
HTH
John
http://www.contextures.com/xlCondFormat01.html