I am looking to conditionally format using AND and OR functions but i cant seem to get it to work.
Basically I am trying to merge the two formulae to make one RULE.
=AND(L17="",A17<>"")
and
=or(C17<>"X",C17<>"Y",C17<>"Z")
but adding a rule that says this:
=AND(L17="",A17<>""),or(C17<>"X",C17<>"Y",C17<>"Z")
doesnt seem to work.......what am i missing?
Bookmarks