Change Font Color when I type the letter

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!
 
B

Bob Phillips

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)
 
A

Arvi Laanemets

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
 

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

Need help modifying code 0
Adding data only if adjacent to cell labeled "male"/"female" 1
Change Letter Color when I type the letter 3
Problem with MS Word paragraph and character styles: format getting messed up 2
Word 2016 - Difficulties Learning Style Creation/Application 0
Change Color of cell 3
Change row colors based on a cell value 1
change color font after updated 3

Top