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" wrote in message
...
I have entered this formula: =IF(B5<2000,"WARNING",IF(B52000,"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