Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how blank data validation cell after changing dependent cell?
Thanks for any help.
Using http://contextures.com/xlDataVal02.html, I have a data validation dependent on another data validation. So when I change the original data validation, and then change the dependent data validation, I only get a choice based upon the original data validation. However, before I choose for the dependent data validation, if I had a previous choice that wasn't possible, that value will still remain, even if I choose the original data validation something that won't have that dependent value. Is there a way to blank out the dependent if it won't be allowed? Sorry if that's confusing. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dependent Data Validation | Excel Discussion (Misc queries) | |||
Data Validation list dependent on contents of another cell | Excel Discussion (Misc queries) | |||
dependent lists on data validation | Excel Discussion (Misc queries) | |||
Data Validation and Dependent Lists Q | Excel Worksheet Functions | |||
Blank Cell Validation | Excel Discussion (Misc queries) |