Change Letter Color when I type the letter

[Anne Fu]

I have a simple colum contains Male and Female info. I
need to know how can I change the letter color when I type
the letter. For example, when I type M, the M will
automatically become BLUE in color; when I type F, the F
will become RED in color. Thanks!

 

[Don Guillett]

Have a look at format>conditional format

 

[Gord Dibben]

Anne

Select the column or range.

Format>Conditional Format>Cell Value is: M. Format to blue.

Add a second condition>Cell Value is: F. Format to red.

NOTE: case-insensitive

Gord Dibben Excel MVP

 

[support]

I am from the MS Excel support department at http://www.enterpriseprojectconsulting.com and we would be happy to assist you in resolving your issue

Thank you

Enterprise Project Consultin