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