LinkBack URL
About LinkBacks
Hi,
I am trying to make a conditional formatting rule, that will turn the entire row red if it doesn't contain "A" or "B". Here is my attempt:
It doesn't seem to be working and I'm not sure how to fix it. Thanks.
=$B12=NOT(OR("A","B")))
Hi,
I am trying to make a conditional formatting rule, that will turn the entire row red if it doesn't contain "A" or "B". Here is my attempt:
It doesn't seem to be working and I'm not sure how to fix it. Thanks.=$B12=NOT(OR("A","B")))
georgedixon, Good morning.
Try to use:
Is that what you want?=AND($B12<>"A",$B12<>"B")
I hope it helps.
...If my answer helped you, Please, click on. * Add Reputation (at left)
Best regards.
Marc?lio Lob?o
Thanks, worked perfectly
You're welcome!
Glad to help.
Have a nice day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks