The below link will help
http://contextures.com/xlDataVal10.html#Create
If this post helps click Yes
---------------
Jacob Skaria
"ÉannaD" wrote:
I want to create drop down lists within excel. The list needs to contain
colours only as the colours represent specific items. Is this possible? And
if so, could someone please give me the formula required or a step by step
guide on how to do it.
Cheers