I have a solution for your question - I think?
I'll have to open your file that you included to observe.
Basically I had the same issue and solved it with nested IF's and AND statements. There may be other shorter methods but this worked for me.
To clarify, you prefer to solve via Excel and not VBA - correct?
Thanks,
Sgt Rock (Mort, like the salt)