I'd like to set up a spreadsheet whe

- Question One is asked, and yes or no is selected from a drop-down pickbox.
- If "Yes", Question Two appears (with a "Yes/No" box); if "No", Question
Four appears (with a "Yes/No" box);
- For Question Two, if "Yes", Question Four appears, and if "No", Question
Three appears (with Yes/No boxes)...

and etc., etc. for seven questions.

Then, based on the answers, I want to display different solutions. There are
twelve different outcomes.

Thoughts?

(I know how to do the pick boxes, but that's about it. I was thinking I
could do the appearing bit with conditional formatting, but what do I know?)