How can you reveal cells with drop down lists, based on conditions?

[ridejc3]

I’m having trouble getting my spread sheet to do the following:


Cell A1 Asks a Y/N question, user answers from a drop down list A2 If the user selects yes from the drop down list, I would like a second question to appear, along with a drop-down list of answers.


So far I’ve been successful using conditional formatting to reveal (by changing the cell’s color) the next question but I can’t get the drop down list to work.


I’d appreciate any help getting this to work…BTW it looks like writing a macros might be the only way to get this to work which opens me up to a whole new world of problems.


Thanks...M

 

[njimack]

One of the following links should help you...
http://www.contextures.com/xlDataVal13.html
http://www.contextures.com/xlDataVal02.html
http://www.contextures.com/xlDataVal15.html

 

[ridejc3]

Thanks njimack, the links are helpful. I'll see if i can modify the solutions in the link to solve my problem.