View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default 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.