Applying conditional cell protection
Whether a cell is write-protected can be made subject to a condition.
For example, to make cell B7 writable on the condition that the value in cell B2 is 2:
Whether a cell is write-protected can be made subject to a condition.
For example, to make cell B7 writable on the condition that the value in cell B2 is 2: