Lock and Unlock cells based on condition

[rup1234]

Hi all,

I want to give the user options which are conditional on another cell. For example, in cell B4 is a dropdown of numbers:
If number is less than 12 than cell I4 will be grayed out, & be locked.
And if number is greater than 12 than cell I4 will be unlocked




I guess I have to do something in visual basic but I never used it before, so I would appreciate it if you could explain every single step


I appreciate your help. Thanks!

 

[Joe4]

There are a bunch of old threads which deal with this.

Here are a few:
https://www.mrexcel.com/forum/excel...unlocking-cells-based-value-another-cell.html
https://www.mrexcel.com/archive/vba/locking-unlocking-cells-based-on-value-in-another-cell/

If you have any issues applying those, post back here.