How do I add colours to an Excel drop down menu?
 

I need to add a different colour to the options in a drop down menu in excel,
I understand it is possible using the combobox, but cannot seem to do it!
any help greatly appreciated!

How do I add colours to an Excel drop down menu?
 

The only way I could do this was by applying a conditional format to the cell
where the drop down box is to be. Ie, if one of the drop down options is to
select is the letter A, then first apply a condition to that cell to format
the cell whenever A is selected.

"vanessa" wrote:

I need to add a different colour to the options in a drop down menu in excel,
I understand it is possible using the combobox, but cannot seem to do it!
any help greatly appreciated!