Hi,

I have Data Validation Lists in cells A1, C1 and E1.
If the user selects the drop down in A1, I would like C1 and E1 to be locked and their drop downs unavailable.

Any ideas?
Thanks