check this out, from a very astute source:
http://www.cpearson.com/excel/colors.aspx
"thewris" wrote:
How do I take a long text list of html, #xxxxxx, or RGB 120,0,25 and fill an
adjacent column with the actual color for each. I know how to do them one at
a time. This is a LONG list.