Conditional Formatting Formula Help

[Lazarus416]

I'm having some trouble puzzling out a Conditional Formatting formula...it uses AND, NOT & OR functions. I want to highlight the cell under the following conditions..(this is not the actual formula I tried)

(B3 NOT "A" OR "B" OR "C") AND (F3 - H1 >= 7)

B3 is text
F3 is a manually input date and H1 is =TODAY

(I could also make B3 = "A" OR "B" OR "C")

Any ideas on how to make it work? Thanks in advance.

 

[Lazarus416]

Sorry, I don't think so.
Let me ask again:
1. If B3="A" do you want the conditional formatting to be triggered?
2. If B3="B" do you want the conditional formatting to be triggered?
3. If B3="C" do you want the conditional formatting to be triggered?
4. If, say, B3="X" do you want the conditional formatting to be triggered?

M.

1. No
2. No
3. No
4. Yes

 

[Marcelo Branco]

1. No
2. No
3. No
4. Yes

So you should use this formula (see my answer in post 3)
=AND(B3<>"A",B3<>"B",B3<>"C",F3-H1>=7)

M.

 

[Lazarus416]

So you should use this formula (see my answer in post 3)
=AND(B3<>"A",B3<>"B",B3<>"C",F3-H1>=7)

M.

Ah yes, I'm tracking now. The OR statement is unnecessary because the AND covers them all anyway. My brain was stuck on needing the OR to include them all. Thank you for the explanation.

 

[Marcelo Branco]

Ah yes, I'm tracking now. The OR statement is unnecessary because the AND covers them all anyway. My brain was stuck on needing the OR to include them all. Thank you for the explanation.

You are welcome.

M.