Thread: Changing the Color of a Word in Formula

I have entered this formula: =IF(B5<2000,"WARNING",IF(B5>2000,"OK"))

I want the word "WARNING" to show up RED and BOLD-TYPED. Is there a way to do this?

--
Message posted via http://www.officekb.com

Hi Rebecca

you can use conditional formatting to do this.

Choose the cell with your IF statement in it and then choose format /
conditional formatting
choose
cell value is
choose
equal to
type
WARNING
click on the FORMAT button
set the formatting as you wish
click OK twice.

BTW What do you want to happen if B5 = 2000, if it is OK then you can
simplify your IF statement as
=IF(B5<2000,"WARNING","OK")
alternatively if you want WARNING change it to
=IF(B5<=2000,"WARNING","OK")

Cheers
JulieD

"Rebecca Cribb via OfficeKB.com" <forum@OfficeKB.com> wrote in message
news:43a1842c0ab64dd1a3ef45dbc2bb98e0@OfficeKB.com...
>I have entered this formula: =IF(B5<2000,"WARNING",IF(B5>2000,"OK"))
>
> I want the word "WARNING" to show up RED and BOLD-TYPED. Is there a way
> to do this?
>
> --
> Message posted via http://www.officekb.com

Not within a formula. Only within text or a macro

--
Don Guillett
SalesAid Software
donaldb@281.com
"Rebecca Cribb via OfficeKB.com" <forum@OfficeKB.com> wrote in message
news:43a1842c0ab64dd1a3ef45dbc2bb98e0@OfficeKB.com...
> I have entered this formula: =IF(B5<2000,"WARNING",IF(B5>2000,"OK"))
>
> I want the word "WARNING" to show up RED and BOLD-TYPED. Is there a way
to do this?
>
> --
> Message posted via http://www.officekb.com

Hi JulieD

THANKS A BUNCH!!! This worked PERFECTLY! I had never used conditional formatting before -- what have I been missing???

--
Message posted via http://www.officekb.com

Hi Rebecca

you're welcome and thanks for the feedback - CF is a very useful little tool
isn't it!

Cheers
JulieD

"Rebecca Cribb via OfficeKB.com" <forum@OfficeKB.com> wrote in message
news:e63e1ff3028340e39bea4c9de242bd99@OfficeKB.com...
> Hi JulieD
>
> THANKS A BUNCH!!! This worked PERFECTLY! I had never used conditional
> formatting before -- what have I been missing???
>
> --
> Message posted via http://www.officekb.com