I am trying to create a drop down list with format
 

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!

I am trying to create a drop down list with format
 

Nothing built into excel allows you to do this.

Tasha wrote:

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!

--

Dave Peterson