Font to change color automatically based on value in cell.

I have a cell that includes a formula for a particular take rate, if that
take rate is over or below the targeted take rate, I would like the font to
change color.

I'm thinking it is an if statement, for example if goal is 20% and value is
21% change font to bold blue.

I am using Excel 2003. Thanks!

You need to use Conditional Formatting

Regards

Trevor


"mtwelsh72" <[email protected]> wrote in message
news:[email protected]...
>I have a cell that includes a formula for a particular take rate, if that
> take rate is over or below the targeted take rate, I would like the font
> to
> change color.
>
> I'm thinking it is an if statement, for example if goal is 20% and value
> is
> 21% change font to bold blue.
>
> I am using Excel 2003. Thanks!
>
>

Use conditional formatting, with a value greater than 20% or a custom format
of [Blue][>0.2]0%;[Black][<=0.2]0%;General

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mtwelsh72" <[email protected]> wrote in message
news:[email protected]...
> I have a cell that includes a formula for a particular take rate, if that
> take rate is over or below the targeted take rate, I would like the font
to
> change color.
>
> I'm thinking it is an if statement, for example if goal is 20% and value
is
> 21% change font to bold blue.
>
> I am using Excel 2003. Thanks!
>
>

Look at Format=>Conditional Formulas

--
Regards,
Tom Ogilvy

"mtwelsh72" <[email protected]> wrote in message
news:[email protected]...
> I have a cell that includes a formula for a particular take rate, if that
> take rate is over or below the targeted take rate, I would like the font
to
> change color.
>
> I'm thinking it is an if statement, for example if goal is 20% and value
is
> 21% change font to bold blue.
>
> I am using Excel 2003. Thanks!
>
>