View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gary Gary is offline
external usenet poster
 
Posts: 273
Default 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.