How to generate drop-down that subsequently displays/hides cells depending on selection

Hi,

Desperately need some help!

I am attempting to generate a drop down that that has two selections which when selected cause certain cells to display or hide.
The function of the document is as a questionnaire which display further questions applicable to the answer within the initial dropdown.
Is this possible?

Thanks

Other than going to VB coding, you can't use one cell to change others. However, the converse is true. That is, one cell or several cells display can be affected by another's. For example, you have a drop down in A1 of Yes or No (or blank). You can put a formula in other cells so what they display is keyed off the value of A1. For example, =IF(A1="Yes","Display this message in this cell","Otherwise this message") in any other cell.

Imagine the scenario that the initial question is a simple yes/no. If the user selects yes, then what I would like is for a number of cells to display.

Originally Posted by DannyB234

Imagine the scenario that the initial question is a simple yes/no. If the user selects yes, then what I would like is for a number of cells to display.

See attached...