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