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:

  1. Right-click cell B2 and select Format Cells.
  2. On the Protection tab, clear the Cells check box.
  3. On the Border tab, select a border for the cell.
  4. Right-click cell B7 and select Conditional Formatting.
  5. Create a formula condition with B2=2 as the formula.
  6. Select the condition in the List of conditions and click Edit Entry Format.
  7. Clear the Cells check box on the Protection tab.
  8. On the Border tab, select a border for the cell.
    The border is required in this example so that you can identify the cell in View Mode.
  9. Click OK in the Conditional Formatting dialog.
  10. In View Mode, enter 2 in cell B2 and press Return.
    You can now enter a value into cell B7. If you change the value in cell B2, cell B7 is no longer editable.