How to make a cell with secure data entry?

P

PiShim2021-03-01 08:30:43

Google Sheets

PiShim, 2021-03-01 08:30:43

Good afternoon. I can't think of a script or logic to protect cell input data. The essence of the task is as follows: There is a Range A1: A100, it contains the data "Marriage", "Export". In the range B1:B100, each cell has a drop-down list with values already written. It is necessary that if in A1=Rejection, then B1 could not enter values, and so on through the ranges.

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

V

Vladimir, 2021-03-01
@AstraVlad

Set up data validation using a custom formula like "=NOT(A1="Reject")" and check the box "Prohibit data entry". Plus, a message can be added for complete happiness with an explanation of the reasons.

V

Vladimir Yurchenkov, 2021-03-01
@EPIDEMIASH

If we are talking about online Google spreadsheets, then just select the range , then RMB -> Protect range
. A menu will open on the right and you can configure it there.
If in normal excel too I can prompt.