How Excel tables set content can only be entered without modification

One, the effect demonstration

1, you enter the sales record in the form.

2, responsible for "audit" colleagues open your form, check the correct after the E column selected "audited."

3, you can add new records, but if you want to modify the "audited" record, pop-up warning and you can no longer modify.

4, you want to, "has been audited" deleted, you can modify it. But the reality is brutal, you must enter the permission password to be possible to modify.

　　Second, the realization steps:

1, select the E column area, data-data validation-allow "sequence", in the following box, enter "audited." This step can be generated in the E column to pull down the selected menu.

2, select the E-column area, review-allow users to edit the area-add area and password.

3, select A:d input area, ctrl+1 Open the Cell Formatting window, protection-Cancel the "lock" before the hook.

4, select the input area of the A:d column A2:D14, data-validity-custom-Enter the formula in the formula box:

=len ($E 2) =0

5, and then click on "Error Warning", enter the title and warning content.

6, the final protection of the worksheet.

At this point, the operation is complete!