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
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.
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
Click OK and copy