Double Drop-Down Validation in Excel 2007
 

Is there a way to make the drop-down list that appears for cell validation
conditional on the value in another dropdown cell? Suppose one cell contains
a drop-down list containing categories like Country, State and City. I want
to be able to select the country in dropdown list n 1 and automaticaly
displays only the states that belongs to the selected country on dropdown
list n 1 in the dropdwon list n2. As well as when I choose the state
(dropdown list n 2) it will anable the cities that belong to that state in
drop down n3.