Applying cell protection

In Design View, right-click the cell or cells to format and select Format Cells.

Click the Protection tab.

Clear the Cells check box to make the cell editable.

You can make cell protection conditional by applying conditional formatting.

SeeApplying conditional cell protection.