View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Shacks Shacks is offline
external usenet poster
 
Posts: 3
Default 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!