Conditional Formatting: Using OR & AND Statement

[Disarmonious]

Hello,

I want the text to turn red (cell BY6) if these conditions are NOT met;

C6="Apple"
BT6="No"
BZ6<>1

AA6<>"A: Cherry"
AA6<>"A: Strawberry"
AA6<>"A: Watermelon”
AA6<>"A: Orange"
AA6<>"A: Banana"

I was trying to use this formula, but Excel didn't like it; =OR(AA6<>"A: Cherry",AA6<>"A: Strawberry",AA6<>"A: Watermelon”,AA6<>"A: Orange",AA6<>"A: Banana",AND(C6="Apple",BT6="No",BZ6<>1))

Thank you in advance!

 

[Fluff]

Change the OR to AND

 

[Disarmonious]

Thank you Fluff! Seems like it worked out.

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Disarmonious]

Hey Fluff,

So when I enter these in, I get this error;

when I put the ' before the = sign, it accepts it, but the conditional formatting for these cells don't seem to be functioning (text does not turn red). Is there another way to enter these formulas in that excel will accept without having to add apostrophes?

 

[Fluff]

So when I enter these in

Enter what in? Where?
Adding an apostrophe before the = sign, means it is now text & not a formula

 

[Disarmonious]

So when I enter =AND(AA6<>"A: Cherry",AA6<>"A: Strawberry",AA6<>"A: Watermelon”,AA6<>"A: Orange",AA6<>"A: Banana",AND(C6="Apple",BT6="No",BZ6<>1)) into cell BY6 (which will display a red check mark if those conditions are NOT met), excel prompts that message. I'm wondering if there's another way to enter this formula for the conditional formatting to work?

 

[Disarmonious]

under conditional formatting. I'm entering this into conditional formatting, sorry.

 

[Fluff]

The quote mark after Watermelon is wrong, it should be a " not a ”