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. |
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. |
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. |
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. |
All times are GMT +1. The time now is 12:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com