data validation question

yes, you can do that


First create the list somewhere in the spreadsheet in a single column.

Then select that list and go to Insert|Name|Define and in the field at the top (names in workbood) enter the word "yes" (without quotes). Click OK

Now select any blank cell (that won't ever be used) and repeat the naming process above calling that cell "no"....again no quotes.

Now select D1 (cell next to your yes/no dropdown) and go to Data|Validation and select List. In the source field enter formula: =INDIRECT(C1) and click Ok.

Now, when user selects yes in C1, he gets a list of flavours in D1. If he selects no in C1, he gets a blank list.

No problem.

Good Night and Good luck.