I am trying to have the drop down values of one cell dependent on the selected drop down value of another cell. What I have is:
Cell a1: Value can be either Yes or No
Cell a2: Value can be California, Colorado or Connecticut if a1 is Yes but if it is No then the only allowable values are...