Hi there, I'll try to explain my situation first

i have two cells next to each other

A1 | B1

Now A1 can either be "Yes" or "No"
If A1 is Yes, then B1 is automatically "N/A" - i can do this with a
simple IF statement.
BUT for B1 i want to use a drop down list of 4 options, so when A1 is
No then B1 can be any of the four options, BUT if A1 is No, then B1 is
automatically (and always) N/A


Please could someone help me do this...