Drop Down Menu - dependencies

Giganews Newsgroups
Subject: Drop Down Menu - dependencies
Posted by:  Lorena
Date: Tue, 23 May 2006

I have a spreadsheet that I've created all the necessary naming for the
various drop-down menus.  However, I cannot get a cell (that depends on a
choice in one column) to go blank to force the user to make a selection from
the new group of selections.

Example:  Column A I choose Cat, B - I get choices of colors (brown, gray,
etc.)
If I choose Column A to be Snake, I want be to go blank, and then the new
selections be ready in the pull down area (green, yellow, etc.)

Is this possible?

--
Lori DeMoss
HP Administrator

Replies