Re: Change Font Color when I type the letter

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Arvi Laanemets (garbage_at_hot.ee)
Date: 05/18/04 

Date: Tue, 18 May 2004 21:05:24 +0300

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" <anonymous@discussions.microsoft.com> wrote in message
news:eb5401c43d00$8c358ab0$a101280a@phx.gbl...
> 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!

Relevant Pages

  • Re: Want black box 2x3" with white lettering
    ... And of course, if you want to override Word's choice, you have to set font color explicitly. ... Microsoft MVP (Word) ... But I have found many printer drivers that get confused by automatically reversed colours and ignore the reversed colour, resulting in this example as black text over a black background. ...
    (microsoft.public.word.newusers)
  • RE: Issue in conditional formatting
    ... Condition1 sets textbox1 font color to blue when it gets the focus. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Hyperlink Colors
    ... Highlight link, ... Set font color to color want, ... FrontPage Resources, WebCircle, MS KB Quick Links, etc. ...
    (microsoft.public.frontpage.client)
  • Issue in conditional formatting
    ... Condition1 sets textbox1 font color to blue when it gets the focus. ...
    (microsoft.public.access.modulesdaovba)
  • Re: coditional formatting
    ... "Biff" wrote: ... > If the default font color is black then you only need one condition: ... > Set font color to BLACK ... >> Divide each cell by 100,000 ...
    (microsoft.public.excel.worksheet.functions)