| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional format combined with functions | Excel Worksheet Functions | |||
| grayscale conditional formatting of text | Excel Discussion (Misc queries) | |||
| Cell Format Changes When Data Is Entered - Not Conditional Formatt | Excel Worksheet Functions | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| How do i change numbers in text format to number format? | New Users to Excel | |||
Linear Mode
