I am attempting to expand the conditional formatting from 3 options. In
order to do this, I need to find the number relating to the RGB color
palette. Is there an easier way to find this information rather than
conditionally formatting the same area in a macro over and over again and
writing down the colors I want. I would like to print out a color scale for
later use.

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

Tim

"Nelly" wrote in message
...
I am attempting to expand the conditional formatting from 3 options. In
order to do this, I need to find the number relating to the RGB color
palette. Is there an easier way to find this information rather than
conditionally formatting the same area in a macro over and over again and
writing down the colors I want. I would like to print out a color scale
for
later use.

This might help


Public Enum xlColorIndex
xlCIBlack = 1
xlCIWhite = 2
xlCIRed = 3
xlCIBrightGreen = 4
xlCIBlue = 5
xlCIYellow = 6
xlCIPink = 7
xlCITurquoise = 8
xlCIDarkRed = 9
xlCIGreen = 10
xlCIDarkBlue = 11
xlCIDarkYellow = 12
xlCIViolet = 13
xlCITeal = 14
xlCIGray25 = 15
xlCIGray50 = 16
xlCIPeriwinkle = 17
xlCIPlum = 18
xlCIIvory = 19
xlCILightTurquoise = 20
xlCIDarkPurple = 21
xlCICoral = 22
xlCIOceanBlue = 23
xlCIIceBlue = 24
'xlCIDarkBlue = 25
'xlCIPink = 26
'xlCIYellow = 27
'xlCITurquoise = 28
'xlCIViolet = 29
'xlCIDarkRed = 30
'xlCITeal = 31
'xlCIBlue = 32
xlCISkyBlue = 33
xlCILightGreen = 35
xlCILightYellow = 36
xlCIPaleBlue = 37
xlCIRose = 38
xlCILavender = 39
xlCITan = 40
xlCILightBlue = 41
xlCIAqua = 42
xlCILime = 43
xlCIGold = 44
xlCILightOrange = 45
xlCIOrange = 46
xlCIBlueGray = 47
xlCIGray40 = 48
xlCIDarkTeal = 49
xlCISeaGreen = 50
xlCIDarkGreen = 51
xlCIBrown = 53
xlCIIndigo = 55
xlCIGray80 = 56
End Enum



--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Nelly" wrote in message
...
I am attempting to expand the conditional formatting from 3 options. In
order to do this, I need to find the number relating to the RGB color
palette. Is there an easier way to find this information rather than
conditionally formatting the same area in a macro over and over again and
writing down the colors I want. I would like to print out a color scale
for
later use.