I've created a list and I want to keep the text color format. I have a list
of 100 items. 25 have blue text, 25 red, 25 yellow, and 25 green. I created
a list if these text items. When I select the cell I want to insert a list
(though DataValidation) all my list items are the default black text.

How can I keep the colors in the list?

Thanks,

Chris