| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Complex cond. formatting...Pls. Help!
Hi again! I have a cell in excel that has this formula: =AND(E3<D3,TODAY()G3). I sometimes need E3 to display something like 3+1, meaning that I received two different shipments. I want excel to be able to calculate the 3+1, while still performing the formula mentioned above. I don't need excel to display the answer to 3+1, but I need it to know the answer and recognize that 3+1 received items is equal to the 4 items ordered. Thanks. -- Roz ------------------------------------------------------------------------ Roz's Profile: http://www.excelforum.com/member.php...o&userid=29746 View this thread: http://www.excelforum.com/showthread...hreadid=494970 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I apply Cond. Formatting to a Formula result? | Excel Worksheet Functions | |||
| Formula help for complex formatting. | Excel Worksheet Functions | |||
| Conditional Formatting Reference / Inserting Rows | Excel Worksheet Functions | |||
| complex?? Q about Conditional formatting | Excel Worksheet Functions | |||
| difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
Threaded Mode
