I thought it was conditional formatting but I didn't know
how to set it up.

Thanks again.

-----Original 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


.