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!