{"id":293,"date":"2018-09-19T17:16:40","date_gmt":"2018-09-19T08:16:40","guid":{"rendered":"https:\/\/blog.wewidi.com\/?p=293"},"modified":"2018-09-20T13:39:13","modified_gmt":"2018-09-20T04:39:13","slug":"%e3%80%90excelvba%e3%80%91colorindex%e3%81%ae%e7%95%aa%e5%8f%b7%e3%81%a8%e8%89%b2%e3%81%ae%e5%af%be%e5%bf%9c","status":"publish","type":"post","link":"https:\/\/blog.wewidi.com\/?p=293","title":{"rendered":"\u3010ExcelVBA\u3011ColorIndex\u306e\u756a\u53f7\u3068\u8272\u306e\u5bfe\u5fdc"},"content":{"rendered":"

\u30bb\u30eb\u306e\u80cc\u666f\u8272\u3084\u6587\u5b57\u8272\u306a\u3069\u3092\u6307\u5b9a\u3059\u308b\u5834\u5408\u306f\u3001RGB\u5024\u3067\u6307\u5b9a\u3059\u308b\u304b\u3001Index\u5024\u3067\u6307\u5b9a\u3059\u308b\u3002<\/p>\n\n\n\n\n\n
<\/td>\n\u6587\u5b57\u8272<\/td>\n\u80cc\u666f\u8272<\/td>\n<\/tr>\n
RGB\u6307\u5b9a<\/td>\n.Font.Color<\/td>\n.Interior.Color<\/td>\n<\/tr>\n
Index\u6307\u5b9a<\/td>\n.Font.ColorIndex<\/td>\n.Interior.ColorIndex<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u3055\u3066\u3001ColorIndex\u306b\u6307\u5b9a\u3059\u308bIndex\u5024\u306b\u5bfe\u5fdc\u3059\u308b\u8272\u306f\uff1f\uff1f\u3068\u3044\u3046\u3053\u3068\u3067\u3001\u8abf\u3079\u3066\u307f\u305f\u3002
\n\u3061\u306a\u307f\u306b\u3001ColorIndex\u306f\u30011\uff5e56\u306e\u7bc4\u56f2\u3089\u3057\u3044\u3002<\/p>\n

ColorIndex\u306e\u8a2d\u5b9a\u8272<\/p>\n\n\n\n
\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
No.<\/td>\nColor<\/td>\nRGB\u5024<\/td>\nRGB()<\/td>\n<\/tr>\n
1<\/td>\n#000000<\/td>\n0<\/td>\n0, 0, 0<\/td>\n<\/tr>\n
2<\/td>\n#FFFFFF<\/td>\n16777215<\/td>\n255, 255, 255<\/td>\n<\/tr>\n
3<\/td>\n#FF0000<\/td>\n255<\/td>\n255,0,0<\/td>\n<\/tr>\n
4<\/td>\n#00FF00<\/td>\n65280<\/td>\n0, 255,0<\/td>\n<\/tr>\n
5<\/td>\n#000000<\/td>\n16711680<\/td>\n0,0, 255<\/td>\n<\/tr>\n
6<\/td>\n#FFFF00<\/td>\n65535<\/td>\n255, 255,0<\/td>\n<\/tr>\n
7<\/td>\n#FF00FF<\/td>\n16711935<\/td>\n255,0, 255<\/td>\n<\/tr>\n
8<\/td>\n#00FFFF<\/td>\n16776960<\/td>\n0, 255, 255<\/td>\n<\/tr>\n
9<\/td>\n#800000<\/td>\n128<\/td>\n128,0,0<\/td>\n<\/tr>\n
10<\/td>\n#008000<\/td>\n32768<\/td>\n0, 128,0<\/td>\n<\/tr>\n
11<\/td>\n#000080<\/td>\n8388608<\/td>\n0,0, 128<\/td>\n<\/tr>\n
12<\/td>\n#808000<\/td>\n32896<\/td>\n128, 128,0<\/td>\n<\/tr>\n
13<\/td>\n#080080<\/td>\n8388736<\/td>\n128,0, 128<\/td>\n<\/tr>\n
14<\/td>\n#008080<\/td>\n8421376<\/td>\n0, 128, 128<\/td>\n<\/tr>\n
15<\/td>\n#C0C0C0<\/td>\n12632256<\/td>\n192, 192, 192<\/td>\n<\/tr>\n
16<\/td>\n#808080<\/td>\n8421504<\/td>\n128, 128, 128<\/td>\n<\/tr>\n
17<\/td>\n#9999FF<\/td>\n16751001<\/td>\n153, 153, 255<\/td>\n<\/tr>\n
18<\/td>\n#993366<\/td>\n6697881<\/td>\n153,51, 102<\/td>\n<\/tr>\n
19<\/td>\n#FFFFCC<\/td>\n13434879<\/td>\n255, 255, 204<\/td>\n<\/tr>\n
20<\/td>\n#CCFFFF<\/td>\n16777164<\/td>\n204, 255, 255<\/td>\n<\/tr>\n
21<\/td>\n#000000<\/td>\n6684774<\/td>\n102,0, 102<\/td>\n<\/tr>\n
22<\/td>\n#FF8080<\/td>\n8421631<\/td>\n255, 128, 128<\/td>\n<\/tr>\n
23<\/td>\n#0066CC<\/td>\n13395456<\/td>\n0, 102, 204<\/td>\n<\/tr>\n
24<\/td>\n#CCCCFF<\/td>\n16764108<\/td>\n204, 204, 255<\/td>\n<\/tr>\n
25<\/td>\n#000080<\/td>\n8388608<\/td>\n0,0, 128<\/td>\n<\/tr>\n
26<\/td>\n#FF00FF<\/td>\n16711935<\/td>\n255,0, 255<\/td>\n<\/tr>\n
27<\/td>\n#FFFF00<\/td>\n65535<\/td>\n255, 255,0<\/td>\n<\/tr>\n
28<\/td>\n#00FFFF<\/td>\n16776960<\/td>\n0, 255, 255<\/td>\n<\/tr>\n
29<\/td>\n#800080<\/td>\n8388736<\/td>\n128,0, 128<\/td>\n<\/tr>\n
30<\/td>\n#800000<\/td>\n128<\/td>\n128,0,0<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
No.<\/td>\nColor<\/td>\nRGB\u5024<\/td>\nRGB()<\/td>\n<\/tr>\n
31<\/td>\n#008080<\/td>\n8421376<\/td>\n0, 128, 128<\/td>\n<\/tr>\n
32<\/td>\n#0000FF<\/td>\n16711680<\/td>\n0,0, 255<\/td>\n<\/tr>\n
33<\/td>\n#00CCFF<\/td>\n16763904<\/td>\n0, 204, 255<\/td>\n<\/tr>\n
34<\/td>\n#CCFFFF<\/td>\n16777164<\/td>\n204, 255, 255<\/td>\n<\/tr>\n
35<\/td>\n#CCFFCC<\/td>\n13434828<\/td>\n204, 255, 204<\/td>\n<\/tr>\n
36<\/td>\n#FFFF99<\/td>\n10092543<\/td>\n255, 255, 153<\/td>\n<\/tr>\n
37<\/td>\n#99CCFF<\/td>\n16764057<\/td>\n153, 204, 255<\/td>\n<\/tr>\n
38<\/td>\n#FF99CC<\/td>\n13408767<\/td>\n255, 153, 204<\/td>\n<\/tr>\n
39<\/td>\n#CC99FF<\/td>\n16751052<\/td>\n204, 153, 255<\/td>\n<\/tr>\n
40<\/td>\n#FFCC99<\/td>\n10079487<\/td>\n255, 204, 153<\/td>\n<\/tr>\n
41<\/td>\n#3366FF<\/td>\n16737843<\/td>\n51, 102, 255<\/td>\n<\/tr>\n
42<\/td>\n#33CCCC<\/td>\n13421619<\/td>\n51, 204, 204<\/td>\n<\/tr>\n
43<\/td>\n#99CC00<\/td>\n52377<\/td>\n153, 204,0<\/td>\n<\/tr>\n
44<\/td>\n#FFCC00<\/td>\n52479<\/td>\n255, 204,0<\/td>\n<\/tr>\n
45<\/td>\n#FF9900<\/td>\n39423<\/td>\n255, 153,0<\/td>\n<\/tr>\n
46<\/td>\n#FF6600<\/td>\n26367<\/td>\n255, 102,0<\/td>\n<\/tr>\n
47<\/td>\n#666699<\/td>\n10053222<\/td>\n102, 102, 153<\/td>\n<\/tr>\n
48<\/td>\n#969696<\/td>\n9868950<\/td>\n150, 150, 150<\/td>\n<\/tr>\n
49<\/td>\n#003366<\/td>\n6697728<\/td>\n0,51, 102<\/td>\n<\/tr>\n
50<\/td>\n#339966<\/td>\n6723891<\/td>\n51, 153, 102<\/td>\n<\/tr>\n
51<\/td>\n#003300<\/td>\n13056<\/td>\n0,51,0<\/td>\n<\/tr>\n
52<\/td>\n#333300<\/td>\n13107<\/td>\n51,51,0<\/td>\n<\/tr>\n
53<\/td>\n#993300<\/td>\n13209<\/td>\n153,51,0<\/td>\n<\/tr>\n
54<\/td>\n#993366<\/td>\n6697881<\/td>\n153,51, 102<\/td>\n<\/tr>\n
55<\/td>\n#333399<\/td>\n10040115<\/td>\n51,51, 153<\/td>\n<\/tr>\n
56<\/td>\n#333333<\/td>\n3355443<\/td>\n51,51,51<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u304a\u307e\u3051\u3067\u3001ColorIndex\u306e\u4e00\u89a7\u3092\u4f5c\u6210\u3059\u308b\u30de\u30af\u30ed\u3092\u4f5c\u6210\u3057\u3066\u307f\u305f\u306e\u3067\u3001\u4ee5\u4e0b\u306e\u6295\u7a3f\u3092\u53c2\u7167\u3057\u3066\u307b\u3057\u3044\u3002<\/p>\n

\u2192 \u3010ExcelVBA\u3011ColorIndex\u306e\u4e00\u89a7\u3092\u4f5c\u6210\u3059\u308b\u30de\u30af\u30ed\u30b5\u30f3\u30d7\u30eb<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

\u30bb\u30eb\u306e\u80cc\u666f\u8272\u3084\u6587\u5b57\u8272\u306a\u3069\u3092\u6307\u5b9a…<\/p>\n","protected":false},"author":1,"featured_media":184,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[6,40,46,4],"tags":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/blog.wewidi.com\/index.php?rest_route=\/wp\/v2\/posts\/293"}],"collection":[{"href":"https:\/\/blog.wewidi.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.wewidi.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.wewidi.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.wewidi.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=293"}],"version-history":[{"count":32,"href":"https:\/\/blog.wewidi.com\/index.php?rest_route=\/wp\/v2\/posts\/293\/revisions"}],"predecessor-version":[{"id":341,"href":"https:\/\/blog.wewidi.com\/index.php?rest_route=\/wp\/v2\/posts\/293\/revisions\/341"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.wewidi.com\/index.php?rest_route=\/wp\/v2\/media\/184"}],"wp:attachment":[{"href":"https:\/\/blog.wewidi.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=293"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.wewidi.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=293"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.wewidi.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=293"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}