Using validation and a default value

[BrendaK]

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!

 

[Sheeloo]

See http://www.contextures.com/xlDataVal02.html