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?
|