How do I conditionally lock cells?
How can I make the ability to edit a cell conditional based on the value of
another cell? For example if cell A1 contains the value "Yes", cell A2 can
be edited. However if the value in A1 is "No", cell A2 should be locked.
|