One way: set the colour of the font to the same as the background, for
example, white on white. Then use Conditional Formatting on all the cells.
If the value on the drop down box is "yes" then set the font colour to
automatic.

Conditional Formatting | Formulas is: =$A1="yes" Format | Font |
Colour: Automatic

Regards

Trevor


"Mike in OH" <Mike in wrote in message
...
Is it possible to set up a cell with a drop down menu selection of "Yes"
and
"No" such that the selection of "yes" or "no" causes the spreadsheet to
display or hide additional cells with text. I am trying to set up a form
that contains questions that can be answered as yes or no. If the answer
is
yes, I want to display a series of additional questions. Another way
would
be to have an answer of "no" cause some of the cells with additional
questions to disappear. Can this be done?