hi
forgot to mention. only the first 8 colors have official names. all the rest
just have color index numbers.

regards
FSt1

"FSt1" wrote:

hi
formulas return values, they cannot perform actions like set formats.
See this site.
http://www.mvps.org/dmcritchie/excel/colors.htm
down aways on the page is a table with the 56 xl colors plus the HTML, hex
and RGB codes. you can copy and paste it into an xl sheet like i did.

Regards
FSt1

"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).