Share via

Lock drop down list until previous drop down list has been answered.

Anonymous
2024-10-09T01:17:00+00:00

Here is the scenario. I have created questions with drop down options but it's a series of questions. I do not want subsequent questions to be answered until the previous question is answered. I have already used data validation for drop downs and conditional formatting but it does not lock the dropdown. Any suggestions?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.6K Reputation points
    2024-10-09T11:45:41+00:00

    For example:

    Let's say you have a drop-down in B3, with source range =$K$1:$K$6

    You do not want it to be filled in unless B2 is filled in.

    Change the source to

    =IF(B2="", $Z$1, $K$1:$K$6)

    where Z1 is an empty cell (any empty cell will do), and clear the check box 'Ignore blank'.

    Was this answer helpful?

    0 comments