Hi there --

I am setting a 3-level conditional format and the 3rd level is not working.
It includes a 2-part OR statement -- if I put either of the OR items in
individually, the conditional format works. However, the complete OR
statement only works on one portion of the OR. Here's what I'm trying to
accomplish and I have inserted the 3 conditional format statements below.

Col A (Recruiter); Col C (Insertion Date); Col O (Date Phone Scr.
Compelted); Col Q (F2F Completed or N/A); Col 2 (References Completed)

Column A should turn the appropriate color based on the conditional
formatting (if.

Bright Yellow -- Condition 1
=AND(NOT(ISBLANK(C9)),(C9+30)<=TODAY(),ISBLANK(O9) )

Blue -- Condition 2
=AND(NOT(ISBLANK(O9)),(O9+30)<=TODAY(),ISBLANK(Q9) )

Green -- Condition 3
=OR(AND(NOT(ISBLANK(Q9)),OR(Q9<"N/A",Q9<"n/a",Q9<"na",Q9<"NA"),(Q9+30)<=TODAY(),ISBLANK(S9) ),AND(NOT(ISBLANK(O9)),OR(Q9="N/A",Q9="n/a",Q9="na",Q9="NA"),(O9+30)<=TODAY(),ISBLANK(S9 )))

Any help someone can provide would be most appreciated.

Ellen