conditional format text - please help!

[Vivek]

If I have one cell - d32, and when the value becomes negative I want cell E32
to say "Over Budget", would this be possible?

 

[George Gee]

Not entirely sure what you are asking... but see if this helps.
In E32 =IF(D32<0,"Over Budget","")

George Gee

 

[Vivek]

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?

 

[George Gee]

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

 

[Vivek]

Thanks so much, it works!!!

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