Conditional Formatting: Can you combine OR & AND rules?

[wittonlin]

Separately they work fine, but I have a bunch so combining these rules would be fantastic.

=AND($M101="Male", NOT($H101="TN"))

=$H101="KY"

Both my attempts won't work

=OR($H101="KY"),AND($M101="Male", NOT($H101="TN"))

=AND($M101="Male", NOT($H101="TN")),OR($H101="KY")

Is there ANY possible way to combine these rules?

 

[Peter_SSs]

Tell us in words how the conditional formatting should decide whether to apply the format or not.

What cell are you giving us these attempts for?

 

[Norie]

Perhaps.

=OR($H101="KY",AND($M101="Male",$H101<>"TN"))

 

[wittonlin]

Perhaps.

=OR($H101="KY",AND($M101="Male",$H101<>"TN"))

Friggen Fantastic!

Nice touch, I didn't think about '<>' and removing that one bracket was the key!

Now I was able to do them all! Even with a legitimate already OR statement!

=OR($H101="TN", $H101="OK")

=AND($M101="Male", NOT($H101="KY"))

It works perfectly here too!

=OR($H101="TN", $H101="OK",AND($M101="Male", $H101<>"KY"))

Thank you AGAIN Norie!