Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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) |