Formatting Certain Words
 

I have an excel sheet that lists members of a department. Next to their name
in column B they need to put yes, no or maybe. As they type their answer I
would like yes to be red, no to go blue and maybe to go green. Can you format
cells based on what answer they put in the cell? So as yes is typed the word
goes to red?

Thanks,

Shane

Formatting Certain Words
 

Use Conditional Formatting:

Format Conditional formatting Formula is:
=A1="yes"
and pick a red font

repeat for blue and green.
--
Gary''s Student - gsnu200722