It seems like something that should be UTTERLY FUCKING SIMPLE isn’t possible, or possibly I am rubbish at Googling for Excel stuff.
Anyway here’s what I want:
If the value in cell $B$2 is one of two possible values then UNprotect cells $C$2 and $D$2 so that the user can select something from the drop downs in those cells. Otherwise leave them protected.
Now the check on $B$2 is trivial but I cannot for the life of me see how I can control the two cells?