Hello,
I'm new to the forum so please forgive any lapses in board ettiquette.
The question is...
Can I lock/unlock cells that contain drop down data validations based on the result of another drop down validation. And if so how?
eg - relates to attached file.
C12 is a drop down. Variables are Select, Yes, No (Select is really just an instruction to users)
If Yes is selected value I want cells M12:R12 to be unlocked allowing access to the drop downs they contain. Any other result for C12 should leave M12:R12 locked.
Columns M-R have CountIf functions against the Yes results but I need these only to be returned where C12-22 value = Yes.
Hopefully the attached file helps to illustrate the problem.
Any help much appreciated.
Neil
Bookmarks