Building a drop down selection menu

[Terry Haber]

I cannot seem to figure out how to build a list and then
convert it into a drop down menu.

For example:

I would like to create a list of cars, and next to each
one I would like to have a drop down list that allows me
to choose a color.

Truck (Drop down list: red, green, blow)
Car
Van

 

[JulieD]

Hi Terry

have a look at Data Validation on Debra Dalgleish's site ..
www.contextures.com/tiptech.html

Regards
JulieD

 

[Dave Peterson]

It looks like Data|validation would be sufficient.
Debra Dalgleish has some tips for Data|validation at:
http://www.contextures.com/xlDataVal01.html