| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation-Dependent Lists | Excel Discussion (Misc queries) | |||
| Data validation dependent lists | Excel Discussion (Misc queries) | |||
| dependent lists on data validation | Excel Discussion (Misc queries) | |||
| Data Validation and Dependent Lists Q | Excel Worksheet Functions | |||
| Dependent List- Data Validation | Excel Worksheet Functions | |||
Threaded Mode
