How to apply conditional data validation when a cell with a defined value is changed?
Web Applications Asked by screampuff on February 22, 2021
I have a spreadsheet that’s basically a grid checklist, let’s say 10 columns and 20 rows.
There are multiple cells that have N/A as the value, and I’m worried going through the checklist that one might accidentally be changed.
So I’d like to protect all cells that equal N/A and show a warning if that value is changed. However other cells that do not have N/A should not be validated.
Is this possible, without or with a script?
One Answer
without a script, you can set up data validation with a custom formula
=COUNTIF(A1,"=N/A")
and then copy A1 cell, select all cells in the grid and paste only data validation:
Answered by user0 on February 22, 2021
Add your own answers!
Ask a Question
Get help from others!
Recent Answers
- Lex on Does Google Analytics track 404 page responses as valid page views?
- Peter Machado on Why fry rice before boiling?
- Jon Church on Why fry rice before boiling?
- Joshua Engel on Why fry rice before boiling?
- haakon.io on Why fry rice before boiling?
Recent Questions
- How can I transform graph image into a tikzpicture LaTeX code?
- How Do I Get The Ifruit App Off Of Gta 5 / Grand Theft Auto 5
- Iv’e designed a space elevator using a series of lasers. do you know anybody i could submit the designs too that could manufacture the concept and put it to use
- Need help finding a book. Female OP protagonist, magic
- Why is the WWF pending games (“Your turn”) area replaced w/ a column of “Bonus & Reward”gift boxes?