Conditional Formatting Help

[Disarmonious]

Hello,

I would like the text in cells CQ6:CQ45 to turn red when these words DO NOT appear in cells AA6:AA45;

"A: Apples (w/C)","A: Bananas","A: Oranges + Add","I: Sugarloafs","Q: Donuts"

I've tried using this formula in Conditional Formatting, and I'm stumped as to why it's not working.

=OR(AA6<>"A: Apples (w/C)",AA6<>"A: Bananas",AA6<>"A: Oranges + Add",AA6<>"I: Sugarloafs",AA6<>"Q: Donuts")

 

[6StringJazzer]

Your problem is in how you are using Boolean logic. Change the OR to AND.

 

[Disarmonious]

Your problem is in how you are using Boolean logic. Change the OR to AND.

Thank you! That worked my friend!

 

[6StringJazzer]

You are welcome!

A lot of novices confuse when to use AND vs. OR, especially when the conditions are negative. You want the whole expression to be true only when ALL of the tests are TRUE, so you need AND. With OR only one of the tests has to be true. When all of your tests are for <>, at least one of them has to be true. So the version with OR is always TRUE for any value in the cell.