ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   typing in color (https://www.excelbanter.com/excel-worksheet-functions/7656-typing-color.html)

Pam Coleman

typing in color
 
Is there a way, if I am typing in one column either a y or n, to make the y
red and the n blue without having to go and change the font color each time?
Would a macro know to change y to red when I type and n to blue?

Frank Kabel

Hi
use 'Format - conditionaö format'

--
Regards
Frank Kabel
Frankfurt, Germany

"Pam Coleman" schrieb im
Newsbeitrag ...
Is there a way, if I am typing in one column either a y or n, to make

the y
red and the n blue without having to go and change the font color

each time?
Would a macro know to change y to red when I type and n to blue?




All times are GMT +1. The time now is 04:32 PM.

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