Conditional Formatting Nested IF's

I've got columns A and B. Both have pull down lists. I want to apply conditional formatting to the cells in column B based on the following: If A is not equal to 1 or 2, and if B contains data, the highlight B Red, otherwise, no color.

The formula I have worked up is as follows, but it seems to be doing the opposite of what I want it to do.

(OR(AND(B1>0,A1<>1),AND(B1>0,A1<>2)))
Then highlight B Red.

Thus, if B contains data and A is either 1 or 2, no highlight. If B contains data and A is 3, 4, 5, etc, highlight B Red.

Any help would be greatly appreciated. Thanks.

Originally Posted by ChemistB

Please Login or Register  to view this content.

That should work. Thanks Chemist!