ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Changing letter color in Excell (https://www.excelbanter.com/excel-programming/274148-re-changing-letter-color-excell.html)

jeff

Changing letter color in Excell
 
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


.



All times are GMT +1. The time now is 11:43 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com