I want a drop down menu (Validation "List", maybe?) and show different colors on the drop down menu.
I changed some cell colors and Insert:Name:Defined them as "Colors" then I went and did a Data:Validation:List:=Colors and it did the drop down like I thought but it had no colors.

I need the user to have a drop down menu with an assortment of colors to choose from.

Thank you,