Change Font Color when I type the letter

  • Thread starter Thread starter Anne Fu
  • Start date Start date
A

Anne Fu

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 (Format>Conditional 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)
 
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
 
Back
Top