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?

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?

Yep.

You could use data|Validation to allow only yes/no and a worksheet event that
would run when a cell changed.

Debra Dalgleish has some notes for data|validation:
http://www.contextures.com/xlDataVal01.html

Chip Pearson has notes about worksheet events:
http://www.cpearson.com/excel/events.htm

David McRitchie's notes:
http://www.mvps.org/dmcritchie/excel/event.htm

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm


Mike in OH wrote:

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?

--

Dave Peterson

You could have something like:

=IF(A1="Yes","Another question ...","")

Hope this helps.

Pete

Mike in OH wrote:
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?