Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Validation
Thanks Debra,
However, if I may use your example, I would like to allow cell B3 the Yes and No option at all times. By saying Yes in B3, pulldowns would not be allowed in either cells C3 and D3 and must be blank. If No is selected in B3 then pulldowns have to be available for selection. If in a previous setup, B3 was No and C3 and D3 had values displayed and if B3 was then selected as Yes then the values in C3 and B3 would have to be automatically cleared. Thanks again and have a fun day. |
#2
|
|||
|
|||
Marty, I've added another sample file he
http://www.contextures.com/excelfiles.html Under Data Validation, look for 'Variable Validation' It uses code to clear the cells, and change the validation. marty wrote: Thanks Debra, However, if I may use your example, I would like to allow cell B3 the Yes and No option at all times. By saying Yes in B3, pulldowns would not be allowed in either cells C3 and D3 and must be blank. If No is selected in B3 then pulldowns have to be available for selection. If in a previous setup, B3 was No and C3 and D3 had values displayed and if B3 was then selected as Yes then the values in C3 and B3 would have to be automatically cleared. Thanks again and have a fun day. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
Debra: Thank You, Thank You!!! Perfect! Boy this is great!! Marty |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation Window? | Excel Discussion (Misc queries) | |||
list validation using list validation... | Excel Worksheet Functions | |||
Validation list behaving strangely in 2003 | Excel Worksheet Functions | |||
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) | |||
Data Validation | Excel Worksheet Functions |