Get documents about "HTML Colors (Excel)
Document Sample
RGB HSB
Solid Forecolor Example, Forecolor Example, Backcolor Backcolor
Color Name Red Green Blue Hue Sat Bright Example Black background White background Example, White text Example, Black text
White 255 255 255 0 0 1 White White White White
WhiteSmoke 245 245 245 0 0 0.961 WhiteSmoke WhiteSmoke WhiteSmoke WhiteSmoke
Gainsboro 220 220 220 0 0 0.863 Gainsboro Gainsboro Gainsboro Gainsboro
LightGrey 211 211 211 0 0 0.827 LightGrey LightGrey LightGrey LightGrey
Silver 192 192 192 0 0 0.753 Silver Silver Silver Silver
DarkGray 169 169 169 0 0 0.663 DarkGray DarkGray DarkGray DarkGray
Gray 128 128 128 0 0 0.502 Gray Gray Gray Gray
DimGray 105 105 105 0 0 0.412 DimGray DimGray DimGray DimGray
Black 0 0 0 0 0 0 Black Black Black Black
RosyBrown 188 143 143 0 0.239 0.737 RosyBrown RosyBrown RosyBrown RosyBrown
Lightcoral 240 128 128 0 0.467 0.941 Lightcoral Lightcoral Lightcoral Lightcoral
IndianRed 205 92 92 0 0.551 0.804 IndianRed IndianRed IndianRed IndianRed
Brown 165 42 42 0 0.745 0.647 Brown Brown Brown Brown
FireBrick 178 34 34 0 0.809 0.698 FireBrick FireBrick FireBrick FireBrick
Red 255 0 0 0 1 1 Red Red Red Red
DarkRed 139 0 0 0 1 0.545 DarkRed DarkRed DarkRed DarkRed
Maroon 128 0 0 0 1 0.502 Maroon Maroon Maroon Maroon
LightPink 255 182 193 0.025 0.286 1 LightPink LightPink LightPink LightPink
Crimson 220 20 60 0.033 0.909 0.863 Crimson Crimson Crimson Crimson
PalevioletRed 219 112 147 0.055 0.489 0.859 PalevioletRed PalevioletRed PalevioletRed PalevioletRed
LavenderBlush 255 240 245 0.056 0.059 1 LavenderBlush LavenderBlush LavenderBlush LavenderBlush
HotPink 255 105 180 0.083 0.588 1 HotPink HotPink HotPink HotPink
DeepPink 255 20 147 0.09 0.922 1 DeepPink DeepPink DeepPink DeepPink
MediumvioletRed 199 21 133 0.105 0.894 0.78 MediumvioletRed MediumvioletRed MediumvioletRed MediumvioletRed
Orchid 218 112 214 0.16 0.486 0.855 Orchid Orchid Orchid Orchid
Thistle 216 191 216 0.167 0.116 0.847 Thistle Thistle Thistle Thistle
Violet 238 130 238 0.167 0.454 0.933 Violet Violet Violet Violet
Fuchsia 255 0 255 0.167 1 1 Fuchsia Fuchsia Fuchsia Fuchsia
Magenta 255 0 255 0.167 1 1 Magenta Magenta Magenta Magenta
DarkMagenta 139 0 139 0.167 1 0.545 DarkMagenta DarkMagenta DarkMagenta DarkMagenta
Purple 128 0 128 0.167 1 0.502 Purple Purple Purple Purple
MediumOrchid 186 85 211 0.2 0.597 0.827 MediumOrchid MediumOrchid MediumOrchid MediumOrchid
DarkViolet 148 0 211 0.216 1 0.827 DarkViolet DarkViolet DarkViolet DarkViolet
DarkOrchid 153 50 204 0.222 0.755 0.8 DarkOrchid DarkOrchid DarkOrchid DarkOrchid
Indigo 75 0 130 0.237 1 0.51 Indigo Indigo Indigo Indigo
BlueViolet 138 43 226 0.247 0.81 0.886 BlueViolet BlueViolet BlueViolet BlueViolet
RGB HSB
Solid Forecolor Example, Forecolor Example, Backcolor Backcolor
Color Name Red Green Blue Hue Sat Bright Example Black background White background Example, White text Example, Black text
MediumPurple 147 112 219 0.279 0.489 0.859 MediumPurple MediumPurple MediumPurple MediumPurple
SlateBlue 106 90 205 0.31 0.561 0.804 SlateBlue SlateBlue SlateBlue SlateBlue
DarkSlateBlue 72 61 139 0.31 0.561 0.545 DarkSlateBlue DarkSlateBlue DarkSlateBlue DarkSlateBlue
MediumSlateBlue 123 104 238 0.31 0.563 0.933 MediumSlateBlue MediumSlateBlue MediumSlateBlue MediumSlateBlue
GhostWhite 248 248 255 0.333 0.027 1 GhostWhite GhostWhite GhostWhite GhostWhite
Lavender 230 230 250 0.333 0.08 0.98 Lavender Lavender Lavender Lavender
MidnightBlue 25 25 112 0.333 0.777 0.439 MidnightBlue MidnightBlue MidnightBlue MidnightBlue
Blue 0 0 255 0.333 1 1 Blue Blue Blue Blue
MediumBlue 0 0 205 0.333 1 0.804 MediumBlue MediumBlue MediumBlue MediumBlue
DarkBlue 0 0 139 0.333 1 0.545 DarkBlue DarkBlue DarkBlue DarkBlue
Navy 0 0 128 0.333 1 0.502 Navy Navy Navy Navy
RoyalBlue 65 105 225 0.375 0.711 0.882 RoyalBlue RoyalBlue RoyalBlue RoyalBlue
CornflowerBlue 100 149 237 0.393 0.578 0.929 CornflowerBlue CornflowerBlue CornflowerBlue CornflowerBlue
LightSteelBlue 176 196 222 0.406 0.207 0.871 LightSteelBlue LightSteelBlue LightSteelBlue LightSteelBlue
LightSlateGray 119 136 153 0.417 0.222 0.6 LightSlateGray LightSlateGray LightSlateGray LightSlateGray
SlateGray 112 128 144 0.417 0.222 0.565 SlateGray SlateGray SlateGray SlateGray
DodgerBlue 30 144 255 0.418 0.882 1 DodgerBlue DodgerBlue DodgerBlue DodgerBlue
AliceBlue 240 248 255 0.422 0.059 1 AliceBlue AliceBlue AliceBlue AliceBlue
SteelBlue 70 130 180 0.424 0.611 0.706 SteelBlue SteelBlue SteelBlue SteelBlue
LightSkyBlue 135 206 250 0.436 0.46 0.98 LightSkyBlue LightSkyBlue LightSkyBlue LightSkyBlue
SkyBlue 135 206 235 0.452 0.426 0.922 SkyBlue SkyBlue SkyBlue SkyBlue
DeepSkyBlue 0 191 255 0.458 1 1 DeepSkyBlue DeepSkyBlue DeepSkyBlue DeepSkyBlue
LightBlue 173 216 230 0.459 0.248 0.902 LightBlue LightBlue LightBlue LightBlue
PowderBlue 176 224 230 0.481 0.235 0.902 PowderBlue PowderBlue PowderBlue PowderBlue
CadetBlue 95 158 160 0.495 0.406 0.627 CadetBlue CadetBlue CadetBlue CadetBlue
DarkTurquoise 0 206 209 0.498 1 0.82 DarkTurquoise DarkTurquoise DarkTurquoise DarkTurquoise
Azure 240 255 255 0.5 0.059 1 Azure Azure Azure Azure
LightCyan 224 255 255 0.5 0.122 1 LightCyan LightCyan LightCyan LightCyan
PaleTurquoise 175 238 238 0.5 0.265 0.933 PaleTurquoise PaleTurquoise PaleTurquoise PaleTurquoise
DarkSlateGray 47 79 79 0.5 0.405 0.31 DarkSlateGray DarkSlateGray DarkSlateGray DarkSlateGray
Aqua 0 255 255 0.5 1 1 Aqua Aqua Aqua Aqua
DarkCyan 0 139 139 0.5 1 0.545 DarkCyan DarkCyan DarkCyan DarkCyan
Teal 0 128 128 0.5 1 0.502 Teal Teal Teal Teal
MediumTurquoise 72 209 204 0.506 0.656 0.82 MediumTurquoise MediumTurquoise MediumTurquoise MediumTurquoise
LightSeaGreen 32 178 170 0.509 0.82 0.698 LightSeaGreen LightSeaGreen LightSeaGreen LightSeaGreen
Turquoise 64 224 208 0.517 0.714 0.878 Turquoise Turquoise Turquoise Turquoise
RGB HSB
Solid Forecolor Example, Forecolor Example, Backcolor Backcolor
Color Name Red Green Blue Hue Sat Bright Example Black background White background Example, White text Example, Black text
Aquamarine 127 205 170 0.556 0.502 1 Aquamarine Aquamarine Aquamarine Aquamarine
MediumAquamarine 102 205 170 0.557 0.502 0.804 MediumAquamarine MediumAquamarine MediumAquamarine MediumAquamarine
MediumSpringGreen 0 250 154 0.564 1 0.98 MediumSpringGreen MediumSpringGreen MediumSpringGreen MediumSpringGreen
MintCream 245 255 250 0.583 0.039 1 MintCream MintCream MintCream MintCream
SpringGreen 0 255 127 0.584 1 1 SpringGreen SpringGreen SpringGreen SpringGreen
MediumSeaGreen 60 179 113 0.592 0.665 0.702 MediumSeaGreen MediumSeaGreen MediumSeaGreen MediumSeaGreen
SeaGreen 46 139 87 0.593 0.669 0.545 SeaGreen SeaGreen SeaGreen SeaGreen
honeydew 240 255 240 0.667 0.059 1 honeydew honeydew honeydew honeydew
DarkSeaGreen 143 188 143 0.667 0.239 0.737 DarkSeaGreen DarkSeaGreen DarkSeaGreen DarkSeaGreen
PaleGreen 152 251 152 0.667 0.394 0.984 PaleGreen PaleGreen PaleGreen PaleGreen
LightGreen 144 238 144 0.667 0.395 0.933 LightGreen LightGreen LightGreen LightGreen
ForestGreen 34 139 34 0.667 0.755 0.545 ForestGreen ForestGreen ForestGreen ForestGreen
LimeGreen 50 205 50 0.667 0.756 0.804 LimeGreen LimeGreen LimeGreen LimeGreen
Lime 0 255 0 0.667 1 1 Lime Lime Lime Lime
Green 0 128 0 0.667 1 0.502 Green Green Green Green
DarkGreen 0 100 0 0.667 1 0.392 DarkGreen DarkGreen DarkGreen DarkGreen
LawnGreen 124 252 0 0.749 1 0.988 LawnGreen LawnGreen LawnGreen LawnGreen
Chartreuse 127 255 0 0.75 1 1 Chartreuse Chartreuse Chartreuse Chartreuse
GreenYellow 173 255 47 0.768 0.816 1 GreenYellow GreenYellow GreenYellow GreenYellow
DarkOliveGreen 85 107 47 0.772 0.561 0.42 DarkOliveGreen DarkOliveGreen DarkOliveGreen DarkOliveGreen
YellowGreen 154 205 50 0.778 0.756 0.804 YellowGreen YellowGreen YellowGreen YellowGreen
OliveDrab 107 142 35 0.779 0.754 0.557 OliveDrab OliveDrab OliveDrab OliveDrab
Ivory 255 255 240 0.833 0.059 1 Ivory Ivory Ivory Ivory
Beige 245 245 220 0.833 0.102 0.961 Beige Beige Beige Beige
LightYellow 255 255 224 0.833 0.122 1 LightYellow LightYellow LightYellow LightYellow
LightGoldenrodYellow250 250 210 0.833 0.16 0.98 LightGoldenrodYellowLightGoldenrodYellowLightGoldenrodYellowLightGoldenrodYellow
Yellow 255 255 0 0.833 1 1 Yellow Yellow Yellow Yellow
Olive 128 128 0 0.833 1 0.502 Olive Olive Olive Olive
DarkKhaki 189 183 107 0.846 0.434 0.741 DarkKhaki DarkKhaki DarkKhaki DarkKhaki
PaleGoldenrod 238 232 170 0.848 0.286 0.933 PaleGoldenrod PaleGoldenrod PaleGoldenrod PaleGoldenrod
LemonChiffon 255 250 205 0.85 0.196 1 LemonChiffon LemonChiffon LemonChiffon LemonChiffon
Khaki 240 230 140 0.85 0.417 0.941 Khaki Khaki Khaki Khaki
Cornsilk 255 248 220 0.867 0.137 1 Cornsilk Cornsilk Cornsilk Cornsilk
Goldenrod 218 165 32 0.881 0.853 0.855 Goldenrod Goldenrod Goldenrod Goldenrod
DarkGoldenrod 184 134 11 0.882 0.94 0.722 DarkGoldenrod DarkGoldenrod DarkGoldenrod DarkGoldenrod
FloralWhite 255 250 240 0.889 0.059 1 FloralWhite FloralWhite FloralWhite FloralWhite
RGB HSB
Solid Forecolor Example, Forecolor Example, Backcolor Backcolor
Color Name Red Green Blue Hue Sat Bright Example Black background White background Example, White text Example, Black text
OldLace 253 245 230 0.891 0.091 0.992 OldLace OldLace OldLace OldLace
Wheat 245 222 179 0.891 0.269 0.961 Wheat Wheat Wheat Wheat
Orange 255 165 0 0.892 1 1 Orange Orange Orange Orange
Moccasin 255 228 181 0.894 0.29 1 Moccasin Moccasin Moccasin Moccasin
PapayaWhip 255 239 213 0.897 0.165 1 PapayaWhip PapayaWhip PapayaWhip PapayaWhip
BlanchedAlmond 255 235 205 0.9 0.196 1 BlanchedAlmond BlanchedAlmond BlanchedAlmond BlanchedAlmond
NavajoWhite 255 222 173 0.9 0.322 1 NavajoWhite NavajoWhite NavajoWhite NavajoWhite
AntiqueWhite 250 235 215 0.905 0.14 0.98 AntiqueWhite AntiqueWhite AntiqueWhite AntiqueWhite
Burlywood 222 184 135 0.906 0.392 0.871 Burlywood Burlywood Burlywood Burlywood
DarkOrange 255 140 0 0.908 1 1 DarkOrange DarkOrange DarkOrange DarkOrange
Bisque 255 228 196 0.91 0.231 1 Bisque Bisque Bisque Bisque
Linen 250 240 230 0.917 0.08 0.98 Linen Linen Linen Linen
PeachPuff 255 218 185 0.921 0.275 1 PeachPuff PeachPuff PeachPuff PeachPuff
SandyBrown 244 164 96 0.923 0.607 0.957 SandyBrown SandyBrown SandyBrown SandyBrown
Seashell 255 245 238 0.931 0.067 1 Seashell Seashell Seashell Seashell
Chocolate 210 105 30 0.931 0.857 0.824 Chocolate Chocolate Chocolate Chocolate
SaddleBrown 139 69 19 0.931 0.863 0.545 SaddleBrown SaddleBrown SaddleBrown SaddleBrown
Sienna 160 82 45 0.946 0.719 0.627 Sienna Sienna Sienna Sienna
LightSalmon 255 160 122 0.952 0.522 1 LightSalmon LightSalmon LightSalmon LightSalmon
Coral 255 127 80 0.955 0.686 1 Coral Coral Coral Coral
OrangeRed 255 69 0 0.955 1 1 OrangeRed OrangeRed OrangeRed OrangeRed
DarkSalmon 233 150 122 0.958 0.476 0.914 DarkSalmon DarkSalmon DarkSalmon DarkSalmon
Tomato 255 99 71 0.975 0.722 1 Tomato Tomato Tomato Tomato
MistyRose 255 228 225 0.983 0.118 1 MistyRose MistyRose MistyRose MistyRose
Salmon 250 128 114 0.983 0.544 0.98 Salmon Salmon Salmon Salmon
ellow
Sub HTMLColorize()
Dim rgbColor As Variant
Dim iR As Integer
Dim iG As Integer
Dim iB As Integer
Dim c As Range
ActiveSheet.Range("H3").Select
For x = 0 To 132
iR = ActiveCell.Offset(x, -6)
iG = ActiveCell.Offset(x, -5)
iB = ActiveCell.Offset(x, -4)
' Set solid cell
rgbColor = RGB(iR, iG, iB)
ActiveCell.Offset(x, 0).Interior.Color = rgbColor
' Forecolor Example, Black background
Set c = ActiveCell.Offset(x, 1)
With c
.Interior.Color = ColorConstants.vbBlack
.Font.Color = rgbColor
End With
' Forecolor Example, White background
Set c = ActiveCell.Offset(x, 2)
With c
.Interior.Color = ColorConstants.vbWhite
.Font.Color = rgbColor
End With
' Backcolor Example, White text
Set c = ActiveCell.Offset(x, 3)
With c
.Interior.Color = rgbColor
.Font.Color = ColorConstants.vbWhite
End With
' Backcolor Example, Black text
Set c = ActiveCell.Offset(x, 4)
With c
.Interior.Color = rgbColor
.Font.Color = ColorConstants.vbBlack
End With
Next x
End Sub
End Sub
