Ask Your Question

Conditional cell protection - SOLVED [closed]

asked 2017-05-15 11:31:16 +0100

MG312 gravatar image

updated 2017-05-20 13:29:22 +0100


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

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by MG312
close date 2017-05-20 13:31:18.446738

2 Answers

Sort by » oldest newest most voted

answered 2017-05-15 17:10:49 +0100

erAck gravatar image

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.

edit flag offensive delete link more

answered 2017-05-20 13:28:47 +0100

MG312 gravatar image

Thanks, that is really helpful!

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2017-05-15 11:31:16 +0100

Seen: 126 times

Last updated: May 20 '17