One final task...changing font color

  • Thread starter Thread starter desperate in MS
  • Start date Start date
D

desperate in MS

I have had a lot of help from and that you all.

One final task and I'm finished with my spreadsheet.

Column B has auto correct for Y=Yes and N=No.

I want to change the font color on Yes to red as it is typed.

Appreciate all ya do
 
Have you looked at Conditional formatting?
I have had a lot of help from and that you all.

One final task and I'm finished with my spreadsheet.

Column B has auto correct for Y=Yes and N=No.

I want to change the font color on Yes to red as it is typed.

Appreciate all ya do
Click to expand...
 
Use the Conditional Formatting.

BTW a spread sheet is never completed, when you learn more you will
always go back and improve it.
 
I have tried conditional formatting but having trouble coming up with the
formula.
 
Back
Top