Excel :Create Drop Down in Excel Sheet(Test Data) with colored font

Create Drop Down in Test Data with colored font

To add this drop-down list to a sheet, do the following:

1. Create the list in cells A1:A4. ...
2. Select cell E3. ...
3. Choose Validation from the Data menu.
4. Choose List from the Allow option's drop-down list. ...
5. Click the Source control and drag to highlight the cells A1:A4. ...
6. Make sure the In-Cell Dropdown option is checked. ...
7. Click OK.

Color coding a drop-down list in Excel's 
    1) Create your drop down list in any cell using Data Validation with fields. e.g, Low, Medium,High
    2) Highlight the drop down cell.
    3) Select Conditional Formatting
    4) Select Highlight cell rules, more rules
    5) Select Format only cells that contain
    6) Change the value in the format only cells with: to Specific Text
    7) Enter the text field . e.g. Low
    Select Format tab.
    9) Select the Fill tab and select your colour e.g. Green.
    10) Click Ok