Ah, ok, so three states:
A1=Y, B1=value, no highlight
A1=Y, B1=blank, highlight
A1=N, B1=blank, no highlight
Is B1 actually blank, or is there a formula making it not have a value(in this case, it isn't blank because the formula resides in the cell, even though you see nothing).
You can do multiple rules, so you can first highlight everything where A1=Y, then the next rule can remove the highlight on cells where B isn't blank.
|