Turning on data validation in one cell based on the contents ofanother cell

[chris.thompson13]

Folks,

I am using MS Excel 2002.

I want to activate data validation in one cell based on the contents
of another cell.

i.e. Cell A1 has data validation for a Yes / No response.
If the user selects Yes in cell A1, I want the data validation (from
another drop down list) to be active in cell A2.
But if the user selects No in cell A1, I want the text "Not
Applicable" to appear in cell A2 and the drop down list not to
appear / be active.

Grateful for any suggestions as to how to achieve this.

Chris

 

[Dave Peterson]

You could use an event macro that changes the validation rules in A2 (along with
the value).

or...

You could continue to use data|validation, but make it so just that single
option shows up as a choice.

Debra Dalgleish explains these dependent lists:
http://contextures.com/xlDataVal02.html