I am trying to create a drop down list with format

  • Thread starter Thread starter Tasha
  • Start date Start date
T

Tasha

I am unable to work out how (if at all possible) I can create a drop down
list that retains the format.
The list I want to create has data in it and the cell is also colour coded.
Have tried to use Conditional formatting, however it only allows 3 options
and I need 6. I do not have the Conditional formatting assistant either!
 
Nothing built into excel allows you to do this.
I am unable to work out how (if at all possible) I can create a drop down
list that retains the format.
The list I want to create has data in it and the cell is also colour coded.
Have tried to use Conditional formatting, however it only allows 3 options
and I need 6. I do not have the Conditional formatting assistant either!
Click to expand...
 

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

Similar Threads

Colour coded drop down list 2
Data Validation/Conditional Formating 3
Excel Formatting in Drop Down Lists 2
Filtered drop down list 2
drop downs showing down arrow 4
Creating drop downs in a cell contingent on another drop down 1
How do I get drop down menu's to show different background colour 3
Drop Down Menu 3

Back
Top