Value List with different colors
I would like to make a drop-down list with each item of the list having a separate fill color. I am only able to figure out how to have one color for all of the list items. I have to assume it's not possible using just the "cutom values" option. I have tried making the list using the "use values from" option mapped to a dedicated table but I still can only figure out one color for the whole list. I have racked my brain about how to do this and have searched the forums with little luck.