conditional format text - please help!
 

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

conditional format text - please help!
 

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

George Gee

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

conditional format text - please help!
 

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" wrote:

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

George Gee

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

conditional format text - please help!
 

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" wrote in message
...
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" wrote:

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

George Gee

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

conditional format text - please help!
 

Thanks so much, it works!!!

"George Gee" wrote:



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" wrote in message
...
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" wrote:

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

George Gee

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