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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top