conditional format text - please help!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If I have one cell - d32, and when the value becomes negative I want cell E32
to say "Over Budget", would this be possible?
 
Not entirely sure what you are asking... but see if this helps.
In E32 =IF(D32<0,"Over Budget","")

George Gee
 
It works, thanks a lot! I also want to do the same thing when D32 is
positive with the same cell. How do you do this?
 
In E32 =IF(D32<0,"Over budget","On Target")

Change the text *On Target* to whatever you wish to appear.
Is this what you want, if not, post back with more details.

George Gee
 
Thanks so much, it works!!!

George Gee said:
In E32 =IF(D32<0,"Over budget","On Target")

Change the text *On Target* to whatever you wish to appear.
Is this what you want, if not, post back with more details.

George Gee
Click to expand...
 
Back
Top