I apologize to both Rona and rizvisa1 for replying this late to this post. Rona, I have prepared for you an excel sheet which has a drop down in cell A1 to select colors and you will see corresponding change in B1. You can download the sheet from the below mentioned link:
I have prepared this sheet using Microsoft Excel 2010. If you have another version of Microsoft Excel, it might not open correctly. If you face any such problem, please reply with the version of Microsoft Excel installed in your computer and I will post the step by step method.
Do reply with results.
Thanks & Regards