If the condition is set to
Cell Value is equal to ="yes"
than it will only respond to yes or Yes and nothing else.

steve

"R. Choate" wrote in message
...
Sure. Use FORMATCONDITIONAL FORMAT. Beware, however, that this will color
everything in the cell red, not just the word "yes". If you only plan to
type "yes" or "no", then it will work great.
--
RMC,CPA


"jeff" wrote in message
...
Hi, Here is my question, Using excell, when I type in Yes
or no into a selected cell, I want Yes to show as red and
no to stay black. Is there a way I can do that so it is
automatic?

Thanks for your help,
Jeff