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

  • Thread starter Thread starter vanessa
  • Start date Start date
V

vanessa

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!
 
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.
 
Back
Top