Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
multiple data validation
Cell A1 requires Yes or No as a result of data validation list
Want second data validation list to then trigger in cell A2 if answer in A1 was Yes and a second one to trigger if answer was No. suggestions please. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
multiple data validation
See this:
http://contextures.com/xlDataVal02.html -- Biff Microsoft Excel MVP "Fiver" wrote in message ... Cell A1 requires Yes or No as a result of data validation list Want second data validation list to then trigger in cell A2 if answer in A1 was Yes and a second one to trigger if answer was No. suggestions please. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
multiple data validation
Perfect! Thanks for the quick response.
"T. Valko" wrote: See this: http://contextures.com/xlDataVal02.html -- Biff Microsoft Excel MVP "Fiver" wrote in message ... Cell A1 requires Yes or No as a result of data validation list Want second data validation list to then trigger in cell A2 if answer in A1 was Yes and a second one to trigger if answer was No. suggestions please. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
multiple data validation
You're welcome!
-- Biff Microsoft Excel MVP "Fiver" wrote in message ... Perfect! Thanks for the quick response. "T. Valko" wrote: See this: http://contextures.com/xlDataVal02.html -- Biff Microsoft Excel MVP "Fiver" wrote in message ... Cell A1 requires Yes or No as a result of data validation list Want second data validation list to then trigger in cell A2 if answer in A1 was Yes and a second one to trigger if answer was No. suggestions please. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Data Validation | Excel Discussion (Misc queries) | |||
multiple data validation | Excel Discussion (Misc queries) | |||
Multiple Data Validation | Excel Worksheet Functions | |||
Multiple Data Validation | Excel Discussion (Misc queries) | |||
Data validation using multiple ranges | Excel Discussion (Misc queries) |