Change Font Color when I type the letter

I need to know how to set up a function (maybe) to change
the font color when I type the letter. For example, I have
a field (column) contains Femal and Male information. I
need to change M in color "Blue" when I type M in the
column; change F in color " Red" when I type F in the
column. Please help and thanks!

Use conditional formatting (FormatConditional Formatting), and test the
values equal to M and F and set the colour accordingly.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Anne Fu" wrote in message
...
I need to know how to set up a function (maybe) to change
the font color when I type the letter. For example, I have
a field (column) contains Femal and Male information. I
need to change M in color "Blue" when I type M in the
column; change F in color " Red" when I type F in the
column. Please help and thanks!

Hi

Select column.
From menu select Conditional Formatting
Condition1: Cell value is - equal to - M
Seelect Format and set font color to blue
Add
Condition2: Cell value is - equal to - F
Seelect Format and set font color to red
OK


--
Arvi Laanemets
(Don't use my reply address - it's spam-trap)


"Anne Fu" wrote in message
...
I need to know how to set up a function (maybe) to change
the font color when I type the letter. For example, I have
a field (column) contains Femal and Male information. I
need to change M in color "Blue" when I type M in the
column; change F in color " Red" when I type F in the
column. Please help and thanks!

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 Consulting