One final task...changing font color
 

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

One final task...changing font color
 

Have you looked at Conditional formatting?

desperate in MS wrote:

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

--

Dave Peterson

One final task...changing font color
 

Use the Conditional Formatting.

BTW a spread sheet is never completed, when you learn more you will
always go back and improve it.

One final task...changing font color
 

I have tried conditional formatting but having trouble coming up with the
formula.

"Dave Peterson" wrote:

Have you looked at Conditional formatting?

desperate in MS wrote:

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

--

Dave Peterson