Conditional cell protection - SOLVED


I put together a spreadsheet, with access by multiple users, with one cell that on certain occasions users may legitimately need to enter a value into. This would overwrite the formula, and to allow this, the cell is unprotected. I want to stop users accidentally changing this cell when they are not supposed to.

Is there a way to protect a cell, but allow users to change the contents provided they are fully aware they are doing it and are correct to change it?

I was thinking of something along the lines of a message that flags up such as “Are you sure?”

Any help gratefully appreciated

I’d rather make the formula depend on another cell like =IF(ISBLANK(A1),yourformula,A1) and have the user input a value into A1. But you can also display a message when the cell is selected using Data → Validity… and on tab Input Help activate “Show input help when cell is selected” and fill Title and/or Input help.

Thanks, that is really helpful!