I want to combine OR and AND to come up with a desired result in conditional formatting but it wont work for me:
my attempt so far is:
=OR($F2="VRI",$F2="Quoted",AND($H2=""))
So I want it to look at cell F2 first and if either of those are present AND H2 is blank then the value is true and the cells can be highlighted.
Bookmarks