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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove Hyperlinks Without Changing background shading 14
Conditional formatting with vba 3
Excel Numbering rows by font color, but skipping blanks 1
Formula needed changing font color 1
Need help with Lotus Notes Automation!!! 0
Change the font color based on the value of the cell 9
At last, ‘Murphy’s Law’ contradicted 7
Changing font color based on type cell it is. How to do it? 6

Back
Top