Conditional Cell Lock

[James8309]

Hi everyone,

I am just having problems with people editing the cell values. I know
how to lock particular cells in a worksheet but how do I achieve
conditional cell lock?

i.e People put inputs in column A and normally Column G:H are locked
for editing. However if input in column A is "ABC" I want to let them
edit or put inputs in Column G:H for that row.

e.g. If A10 = "ABC" then Unlock G10 & H10 and if cell value is other
than "ABC" then lock.

Thank you for your help in advance.


Regards,

James

 

[Joerg Mochikun]

Please don't crosspost. I just tried to answer your question in group
excel.worksheet.functions.
JM

 

[GiaH98]

Hello, I've been trying to look for this exact situation but the opposite. I
would like to lock cell B1 if "abc" is entered in cell B35. Also, is there a
way that when cell B1 locks a specific note pops up for that cell?

Thanks!