VBAではRGB関数を使ってシステムのカラーパレットから色を指定します。
RがRed、GがGrren、BがBlue
数値が大きくなるほど"光る"というイメージで捉えるとイメージが湧きます。RGB(255,255,255)で白、逆にRGB(0,0,0)が黒。
ExcelVBAを使ってLoop文で拾い出してみましたが、量も膨大で判別もしにくいので
ここではWebセーフカラーとして名前のついたものを拾い出しました。
ちなみにこのページはExcelを使って作成しました。
| Color | RGB値 | ColorName | Color | RGB値 | ColorName | Color | RGB値 | ColorName | Color | RGB値 | ColorName | Color | RGB値 | ColorName | Color | RGB値 | ColorName |
| 240,248,255 | aliceblue | 169,169,169 | darkgray | 173,255,47 | greenyellow | 102,205,170 | mediumaquamarine | 221,160,221 | plum | 255,255,0 | yellow | ||||||
| 250,235,215 | autiquewhite | 0,100,0 | darkgreen | 240,255,240 | honeydew | 0,0,205 | mediumblue | 176,224,230 | powderblue | 154,205,50 | yellowgreen | ||||||
| 0,255,255 | aqua | 189,183,107 | darkkhaki | 255,105,180 | hotpink | 186,85,211 | mediumorchid | 128,0,128 | purple | ||||||||
| 127,255,212 | aquamarine | 130,0,139 | darkmagenta | 205,92,92 | indianred | 147,112,219 | mediumpurple | 255,0,0 | red | ||||||||
| 240,255,255 | azure | 255,140,0 | darkorange | 75,0,130 | indigo | 60,179,113 | mediumseagreen | 12,176,224 | richblue | ||||||||
| 245,245,220 | beige | 85,107,47 | darkolivegreen | 255,255,240 | ivory | 123,104,238 | mediumslateblue | 188,143,143 | rosybrown | ||||||||
| 255,228,196 | bisque | 153,50,204 | darkorchid | 240,230,140 | khaki | 0,250,154 | mediumspringgreen | 65,105,255 | royalblue | ||||||||
| 0,0,0 | black | 139,0,0 | darkred | 230,230,250 | lavender | 72,209,204 | mediumturquoise | 139,69,19 | saddlebrown | ||||||||
| 255,235,205 | blanchedalmond | 233,150,122 | darksalmon | 250,240,245 | lavenderblush | 199,21,133 | mediumvioletred | 250,128,114 | salmon | ||||||||
| 0,0,255 | blue | 143,188,143 | darkseagreen | 124,252,0 | lawngreen | 25,25,112 | midnightblue | 244,164,96 | sandybrown | ||||||||
| 138,43,226 | blueviolet | 72,61,139 | darkslateblue | 255,250,205 | lemonchiffon | 245,255,250 | mintcream | 46,139,87 | seagreen | ||||||||
| 181,166,66 | brass | 47,79,79 | darkslategray | 173,216,230 | lightblue | 255,228,225 | mistyrose | 255,245,238 | seashell | ||||||||
| 165,42,42 | brown | 0,206,209 | darkturquoise | 240,128,128 | lightcoral | 255,228,181 | moccasin | 160,82,45 | sienna | ||||||||
| 222,184,135 | burlywood | 148,0,211 | darkviolet | 224,255,255 | lightcyan | 255,222,173 | navajowhite | 192,192,192 | silver | ||||||||
| 95,158,160 | cadetblue | 255,20,147 | deeppink | 250,250,210 | lightgoldenrodyellow | 0,0,128 | navy | 135,206,235 | skyblue | ||||||||
| 127,255,0 | chartreuse | 0,191,255 | deepskyblue | 144,238,144 | lightgreen | 253,245,230 | oldlace | 106,90,205 | slateblue | ||||||||
| 210,105,30 | chocolate | 105,105,105 | dimgray | 211,211,211 | lightgrey | 128,128,0 | olive | 112,128,144 | slategray | ||||||||
| 217,135,25 | coolcopper | 30,144,255 | dodgerblue | 255,182,193 | lightpink | 107,142,35 | olivedrab | 255,250,250 | snow | ||||||||
| 184,115,51 | coper | 209,146,117 | feldsper | 255,160,122 | lightsalmon | 255,165,0 | orange | 0,255,127 | springgreen | ||||||||
| 255,127,80 | coral | 178,34,34 | firebrick | 32,178,170 | lightseagreen | 255,69,0 | orangered | 70,130,180 | steelblue | ||||||||
| 191,239,223 | cornflower | 255,250,240 | floralwhite | 135,206,250 | lightskyblue | 218,112,214 | orchid | 210,180,140 | tan | ||||||||
| 100,149,237 | cornflowerblue | 34,139,34 | forestgreen | 119,136,153 | lightslategray | 238,232,170 | palegoldenrod | 0,128,128 | teal | ||||||||
| 255,248,220 | cornsilk | 255,0,255 | fuchsia | 172,196,222 | lightsteelblue | 152,251,152 | palegreen | 216,191,216 | thistle | ||||||||
| 220,20,60 | crimson | 220,220,220 | gainsboro | 255,255,224 | lightyellow | 173,238,238 | paleturquoise | 255,99,71 | tomato | ||||||||
| 0,255,255 | cyan | 248,248,255 | ghostwhite | 0,255,0 | lime | 219,112,147 | palevioletred | 64,224,208 | turquoise | ||||||||
| 0,0,139 | darkblue | 255,215,0 | gold | 50,205,50 | limegreen | 255,239,213 | papayawhip | 238,130,238 | violet | ||||||||
| 92,40,51 | darkbrown | 218,165,32 | goldenrod | 250,240,230 | linen | 255,218,185 | peachpuff | 245,222,179 | wheat | ||||||||
| 0,139,139 | darkcyan | 128,128,128 | gray | 255,0,255 | magenta | 205,133,63 | peru | 255,255,255 | white | ||||||||
| 184,134,11 | darkboldenrod | 0,128,0 | green | 128,0,0 | maroon | 255,192,203 | pink | 245,245,245 | whitesmoke |