Forum Discussion
Data Validation
Hi I have created a form in excel where I have used data validation to create drop down lists. I also want to apply data validation to some of these cells to not allow the cells to be filled in if a...
You could create a copy of the original validation list with the formula
= IF(replyQ1="yes", optionsQ2, "None")and that becomes your new validation list (it must be a range and not simply an in-memory array).