Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

In excel I was wondering how you go about adding a simple list (data validation) to a range of cells but have the data validation list only appear if the adjacent cell is filled? For example a simple 'Yes, No' list in column B but have it only display if column A is populated, if blank then no data validation. is this possible? Thanks

share|improve this question

You can use the principles of dependent data validation. You need to set up two ranges with the data validation options. Call one range "Yes" and one range "No" and let them have the same values.

Enter yes or no into cell A1 and define the data validation for cell B1 as a list with the reference


If A1 is empty, the data validation list will be empty and any value can be entered in the cell. If A1 contains either yes or no, the data validation will show the list of values.

enter image description here

enter image description here

share|improve this answer

My interpretation of your requirement is not quite the same as @teylyn’s (though hers makes more sense to me!) Say your ‘Yes, No’ list is in F1:F2 and you require to validate from Row1 onwards:

Select B1
Data > Data Tools – Data Validation, Data Validation, for Allow: choose List, and under Source: enter:


Click OK and copy B1 down as far as required.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.