Forum Discussion

Jenni-365's avatar
Jenni-365
Copper Contributor
Feb 04, 2023

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 an answer to a previous question is “no”. I’ve tried lots of formulas but can’t get it to work! Can this be done? 

excel
Formulas and Functions

2 Replies

Sort By
  • PeterBartholomew1's avatar
    PeterBartholomew1
    Silver Contributor
    Feb 04, 2023

    Jenni-365 

    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).

     

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Feb 04, 2023

    Jenni-365 

    Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

Resources