Dependent Data Validation
I have two drop down lists.
1. user selects Yes or No in cell A2
2. If user selects Yes then cell B2 allows user to select from a list of 4
items
3. If user selects No then cell B2 should be blank as the user does not
need to enter anymore information.
I was able to create the dependent drop down list if user selects Yes, but
not sure how to have the blank when user selects No.
Thanks!
|