drop down list format

Hi everyone i am a bit of a novice so sorry if this is easy. I have a group of numbers in a table of spreadsheet. 1. $100 2. $200 3. $300 In the drop-down list in the spreadsheet instead of showing $100, $200, $300 i would like it to say Bronze Silver and Gold. Obviously i still need the...

In cell A1 i have a drop down list with conditional formatting in place. Depending on the value i select, the cell A1 will change fill color. I want cell B1 to change fill color to match the fill color in A1. Simple example: say i select value 1 for cell A1 and the fill color in A1 goes to...

I have a need for the user to enter a code in a cell (Example AUT) however when I display the drop down list I would like the user to see something like (AUT - AUTOCAR), but when the user select it I only want "AUT" to be returned to the cell. I have tried combining the columns for the list, but...

Hello Friends I am using Excel 2007. In my spreadsheet I have created a drop down list for entering values in cells. The master list (from where the drop down list is reading values) has color formats. Is it possible to format cells of the spreadsheet same as the master list? For example if I...