Can I make an Error Alert for a single Data Validation list option in Excel?

Copper Contributor

Hello, I am making a checklist in Excel and sometimes some items are not needed.  I have a column called required and my intent is to put a data validation list with the option "Yes" or "No" in there and then use color rules based on that cell to black out the line if the answer is no. So far I can do all of this.

By default the checklist will be set with everything as yes and I would like the data validation error alert to pop up ONLY if someone chooses "No" so they get a warning before making the change. If they later switch back to "Yes" I don't want an error alert. Is this possible?

1 Reply
I assume you will require VBA macro to do that.