Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hep with Conditionals actions please.
Using Conditionals
In O7 =AND(O7<"",O7<=0) Green =AND(O7<"",O7=1) Red If I delete the date in O5 above, this conditionaL. The cell O7 remains on it's last color, Red or green, it does not revert to white. It will with $, but then I can't copy 800 rows. Is there a an answer? I would like O7 to revert to white if O5 has it's date removed. And have the same type conditionals. Thank you. (Of course or figure how to copy $ down 800 lines and have the cell #'s change accordingly) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditionals containing variables | Excel Discussion (Misc queries) | |||
Different actions on a pivotal value | Excel Worksheet Functions | |||
Conditionals | Excel Worksheet Functions | |||
How to perform two actions ? | Excel Worksheet Functions | |||
Improve autofilter combine conditionals with filter criteria | Excel Worksheet Functions |