Thanks, Paul. I've tried rearranging the conditional formatting. Nothing
solves the problem so far. What I am finding is that the OR statement in the
3rd conditional format is simply not working. Even if I delete statements 1
and 2 and it is the only conditional format statement, it does not work. If I
use either piece of the OR statement by itself, it works. The OR combination
does not. HELP.

Ellen

"Paul H" wrote:



"Ellen G" wrote:

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

Typically I find that if the order of the conditions are changes to reflect
the most likely condition first then the second then the third the
conditional formating will work. Once a condition is met, in say condition
one, the program will no longer look at condition two and/or three.