Disarmonious
Board Regular
- Joined
- Oct 31, 2016
- Messages
- 139
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!
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!