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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting - too many arguments?
Revised & lightly tested,
these 2 expressions were accepted in the CF's Formula Is: (1) Basically as-is, except for removal of extraneous parens: =AND(AND(AI11<"No Response",AI11<"Get Back",AI11<"Returning",AI11<"Returned",AI11<"De ad Case"),OR(AND(AQ11="",AR110,AW11=""),AND(AP110,A R110,AQ11="MS",AW11=""),AND(AR110,AW11="",DAYS36 0(AP11,TODAY())0))) (2) A shorter one, simplifying the first AND criterion via using a defined range "Response" and an ISERROR(MATCH(...)): =AND(ISERROR(MATCH(AI11,Response,0)),OR(AND(AQ11=" ",AR110,AW11=""),AND(AP110,AR110,AQ11="MS",AW11 =""),AND(AR110,AW11="",DAYS360(AP11,TODAY())0 ))) where "Response" is a defined col range for the values: No Response Get Back Returning Returned Dead Case -- Max Singapore http://savefile.com/projects/236895 Downloads:20,000 Files:362 Subscribers:62 xdemechanik --- "Gary" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting - too many arguments?
Thank you MAX. Works like a charm! I used the first simplified revision,
simply because I'm not familiar with defined range. "Max" wrote: Revised & lightly tested, these 2 expressions were accepted in the CF's Formula Is: (1) Basically as-is, except for removal of extraneous parens: =AND(AND(AI11<"No Response",AI11<"Get Back",AI11<"Returning",AI11<"Returned",AI11<"De ad Case"),OR(AND(AQ11="",AR110,AW11=""),AND(AP110,A R110,AQ11="MS",AW11=""),AND(AR110,AW11="",DAYS36 0(AP11,TODAY())0))) (2) A shorter one, simplifying the first AND criterion via using a defined range "Response" and an ISERROR(MATCH(...)): =AND(ISERROR(MATCH(AI11,Response,0)),OR(AND(AQ11=" ",AR110,AW11=""),AND(AP110,AR110,AQ11="MS",AW11 =""),AND(AR110,AW11="",DAYS360(AP11,TODAY())0 ))) where "Response" is a defined col range for the values: No Response Get Back Returning Returned Dead Case -- Max Singapore http://savefile.com/projects/236895 Downloads:20,000 Files:362 Subscribers:62 xdemechanik --- "Gary" wrote: 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting - too many arguments?
Good to hear. Thanks for feeding back & the rating.
-- Max Singapore http://savefile.com/projects/236895 Downloads:20,000 Files:362 Subscribers:62 xdemechanik --- "Gary" wrote in message ... Thank you MAX. Works like a charm! I used the first simplified revision, simply because I'm not familiar with defined range. |
Reply |
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 |