| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting - too many arguments?
Does this conditional formatting equation have too many arguments? If so, is
there a way to simplify the formula to reduce the number of arguments without losing one of my tests? =AND(AND(AI11<"No Response",AI11<"Get Back",AI11<"Returning",AI11<"Returned",AI11<"De ad Case"),(OR(AND(AQ11="",AR110,AW11=""),(AND(AP110 ,AR110,AQ11="MS",AW11=""),(AND(AR110,AW11="",DAY S360(AP11,TODAY())0)))))) I get an unspecified error message when trying to enter it. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| Increase number of conditional format arguments | Excel Discussion (Misc queries) | |||
| Conditional Statement with Multiple Arguments | Excel Worksheet Functions | |||
| conditional sum - number of arguments problem | Excel Worksheet Functions | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Threaded Mode
