This site might be usefull to you.

http://www.mvps.org/dmcritchie/excel/colors.htm

"Jafo1968" wrote:

I want to set up a worksheet with 1 column the colour name and have the
background of that cell be the colour. I also have a column for the Hex #
associated with that colour for the web. Also included are 3 more columns
each with the corrisponding RGB #'s (ie Column C = R, Column D = G, Column E
= B). Is there a formula that can take the data from each cell columns C,D,E
to create the fill colour for each corrisponding cell in column A?
(ie A3 = Dark Red, Columns CDE3 contain the RGB code for Dark Red, then A4 =
Crimson and CDE4 the RGB code for crimson).