How to create a dropdown list that populates with another list

[eggman2001]

Hello, let's say in a column, I have the following colors:
red
yellow
blue
green
orange

Then, for every cell in another column, I'd like a dropdown list to be
available with those 5 colors available to be selected, and you can
select only one. You select the color, and then the cell gets
populated.

I've seen this done, but I just can't figure out how to do it myself
despite numerous searches.

Any assistance would be appreciated.

 

[eggman2001]

Hello, let's say in a column, I have the following colors:
red
yellow
blue
green
orange

Then, for every cell in another column, I'd like a dropdown list to be
available with those 5 colors available to be selected, and you can
select only one. You select the color, and then the cell gets
populated.

I've seen this done, but I just can't figure out how to do it myself
despite numerous searches.

Any assistance would be appreciated.

Nevermind. I found an article on how to do it.
http://spreadsheets.about.com/od/datamanagementinexcel/qt/20071113_drpdwn.htm

 

[WallyWallWhackr]

Hello, let's say in a column, I have the following colors:
red
yellow
blue
green
orange

Then, for every cell in another column, I'd like a dropdown list to be
available with those 5 colors available to be selected, and you can
select only one. You select the color, and then the cell gets
populated.

I've seen this done, but I just can't figure out how to do it myself
despite numerous searches.

Any assistance would be appreciated.

http://office.microsoft.com/en-us/templates/resistor-value-decoding-tool-version-2-TC102182467.aspx

Color fill methods

For drop down fill variants try:

http://office.microsoft.com/en-us/t...crement-selection-revision-2-TC030008308.aspx

The time increment selector is unique. No macros needed.