Drop down form in excel?

[MasterCoder84]

I am trying to create a drop down menu based off a bunch of data. For example A1 says green, A2 says red, A3 says blue and I need a drop down form that will display those. Any help please?

[davesexcel]

Hi,
You need data validation, I could explain it for you, but this site explains it in detail

http://www.contextures.com/xlDataVal01.html