Whats the best way to create a drop down list in excel?

I want to be able to use the selected text in formulas etc...

For example if the list contained red, green, blue. I want to count how many times blue was selected.

Any help would be appreciated.

Regards

Tom