We're that far, but what I need is for the cell to go blank if I change my
choice. Therefore your example, if I change my mind between fruit and
veggies on line 3, I need cell C3 to go blank forcing me to select a new
item. As yours is, I can change my mind, change from fruit to veggies, and
leave oranges there with no error or issues. I'm attempting to idiot proof a
selectionn proces for a sales force.
--
Lori DeMoss
Administrator


"Bob Phillips" wrote:

I think you need to look at http://www.contextures.com/xlDataVal02.html

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Lorena" wrote in message
...
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