|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
Using validation and a default value
See http://www.contextures.com/xlDataVal02.html
"BrendaK" wrote:
Hi,
I am setting up a spreadsheet using multiple validation lists and would like
to create a dependent validation list, with the following scenario:
The second validation is dependent upon the answer of the first validation,
which is basic using two possible values (yes or no). I need the second
validation to populate the cell automatically as "N/A" if the selected value
of the first list is "No". And if the first value selected is "Yes", then the
validation list should be "yes" or "no".
How can I do this without using a macro, because this needs to be as user
friendly as possible.
Thanks!
|