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

  • Thread starter Thread starter chris.thompson13
  • Start date Start date
C

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
 
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
 
Back
Top