{"id":5601,"date":"2024-04-23T10:17:11","date_gmt":"2024-04-23T01:17:11","guid":{"rendered":"https:\/\/i-kiin.net\/?page_id=5601"},"modified":"2024-04-23T10:17:32","modified_gmt":"2024-04-23T01:17:32","slug":"excel-vba-visual-basic-for-applications-color-index","status":"publish","type":"page","link":"https:\/\/i-kiin.net\/?page_id=5601","title":{"rendered":"Excel VBA (Visual Basic for Applications) Color Index"},"content":{"rendered":"<p>Excel\uc5d0\uc11c VBA\ub85c \uc0c9\uc0c1\uc744 \uc9c0\uc815\ud560 \ub54c \uc544\uc8fc \uc720\uc6a9\ud55c\ub2e4.<\/p>\n<ul>\n<li><a href=\"https:\/\/learn.microsoft.com\/en-us\/office\/vba\/api\/excel.colorindex\" target=\"_blank\" rel=\"nofollow noopener\">ColorIndex property (Excel Graph)<\/a> <span style=\"color: #808000;\"><strong>[1]<\/strong><\/span><\/li>\n<li><a href=\"https:\/\/learn.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/color-constants\" target=\"_blank\" rel=\"nofollow noopener\">Color constants<\/a> <span style=\"color: #008000;\"><strong>[2]<\/strong><\/span><\/li>\n<\/ul>\n<p>\uc0c1\uae30 \ub9c1\ud06c\ub4e4 \ud558\ub098\ub294 \uadf8\ub798\ud504\uc5d0 \uc801\uc6a9\ud55c\ub2e4\uace0 \ub418\uc5b4 \uc788\uc73c\ub098 \uc2e4\uc81c\ub85c\ub294 \uc544\ub798\ucc98\ub7fc \uadf8\ub798\ud504 \ud3ec\ud568\ud558\uc5ec \uc140\uc774\ub4e0 \uae00\uc790\ub4e0 \ubaa8\ub450 \uc9c0\uc815 \uac00\ub2a5\ud558\ub2e4.<\/p>\n<p><code>Range(\"A1\").Font.ColorIndex = 3<\/code><br \/>\n<code>Range(\"A2\").Font.Color = vbBlue<\/code><\/p>\n<p>\uc0c1\uae30 \uc0ac\ub840\ub294 Range \uac1c\uccb4\uc5d0 \uc801\uc6a9\ud55c \uac83\uc774\ub098 Cells \uac1c\uccb4\uc5d0\ub3c4 \uc544\ub798\uc640 \uac19\uc774 \uc801\uc6a9 \uac00\ub2a5\ud558\ub2e4.<\/p>\n<p><code>Cells(1, 2).Font.ColorIndex = 3<\/code><br \/>\n<code>Cells(2, \"B\").Font.Color = vbRed<\/code><\/p>\n<p>\uc0c1\uae30 <span style=\"color: #808000;\"><strong>[1]<\/strong><\/span> \ub9c1\ud06c\uc5d0\uc11c \ubcf4\uc5ec\uc8fc\ub294 Color Index \uac12\uc744 \ubcf4\uc5ec\uc8fc\ub294 Color Palette \ub294 \uc544\ub798\uc640 \uac19\ub2e4.<\/p>\n<p><a href=\"https:\/\/learn.microsoft.com\/en-us\/office\/vba\/images\/colorin_za06050819.gif\" rel=\"lightbox\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5603\" src=\"https:\/\/learn.microsoft.com\/en-us\/office\/vba\/images\/colorin_za06050819.gif\" alt=\"\" width=\"257\" height=\"171\" \/><\/a><br \/>\n<!-- Prepare<a href=\"https:\/\/i-kiin.net\/wp-content\/uploads\/2024\/04\/colorin_za06050819.gif\" rel=\"lightbox\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/i-kiin.net\/wp-content\/uploads\/2024\/04\/colorin_za06050819.gif\" alt=\"\" width=\"257\" height=\"171\" class=\"aligncenter size-full wp-image-5603\" \/><\/a>Prepare --><\/p>\n<p>\uadf8\ub9ac\uace0 [2] \ub9c1\ud06c\uc5d0\uc11c \ubcf4\uc5ec\uc8fc\ub294 Color Constants \ud14c\uc774\ube14\uc740 \uc544\ub798\uc640 \uac19\ub2e4.<\/p>\n<table style=\"border-collapse: collapse; margin-left: auto; margin-right: auto; width: 52.2562%;\">\n<tbody>\n<tr>\n<td style=\"width: 18.8536%;\"><strong>Constant<\/strong><\/td>\n<td style=\"width: 10.9122%;\"><strong>Value<\/strong><\/td>\n<td style=\"width: 11.9451%;\"><strong>Description<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 18.8536%;\">vbBlack<\/td>\n<td style=\"width: 10.9122%;\">0x0<\/td>\n<td style=\"width: 11.9451%;\">Black<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 18.8536%;\">vbRed<\/td>\n<td style=\"width: 10.9122%;\">0xFF<\/td>\n<td style=\"width: 11.9451%;\">Red<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 18.8536%;\">vbGreen<\/td>\n<td style=\"width: 10.9122%;\">0xFF00<\/td>\n<td style=\"width: 11.9451%;\">Green<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 18.8536%;\">vbYellow<\/td>\n<td style=\"width: 10.9122%;\">0xFFFF<\/td>\n<td style=\"width: 11.9451%;\">Yellow<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 18.8536%;\">vbBlue<\/td>\n<td style=\"width: 10.9122%;\">0xFF0000<\/td>\n<td style=\"width: 11.9451%;\">Blue<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 18.8536%;\">vbMagenta<\/td>\n<td style=\"width: 10.9122%;\">0xFF00FF<\/td>\n<td style=\"width: 11.9451%;\">Magenta<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 18.8536%;\">vbCyan<\/td>\n<td style=\"width: 10.9122%;\">0xFFFF00<\/td>\n<td style=\"width: 11.9451%;\">Cyan<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 18.8536%;\">vbWhite<\/td>\n<td style=\"width: 10.9122%;\">0xFFFFFF<\/td>\n<td style=\"width: 11.9451%;\">White<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\uc870\ud68c\uc218: 73<\/p>","protected":false},"excerpt":{"rendered":"<p>Excel\uc5d0\uc11c VBA\ub85c \uc0c9\uc0c1\uc744 \uc9c0\uc815\ud560 \ub54c \uc544\uc8fc \uc720\uc6a9\ud55c\ub2e4. ColorIndex property (Excel Graph) [1] Color constants [2] \uc0c1\uae30 \ub9c1\ud06c\ub4e4 \ud558\ub098\ub294 \uadf8\ub798\ud504\uc5d0 \uc801\uc6a9\ud55c\ub2e4\uace0 \ub418\uc5b4 \uc788\uc73c\ub098 \uc2e4\uc81c\ub85c\ub294 \uc544\ub798\ucc98\ub7fc \uadf8\ub798\ud504 \ud3ec\ud568\ud558\uc5ec \uc140\uc774\ub4e0 \uae00\uc790\ub4e0 \ubaa8\ub450 \uc9c0\uc815 \uac00\ub2a5\ud558\ub2e4. Range(&#8220;A1&#8221;).Font.ColorIndex = 3 Range(&#8220;A2&#8221;).Font.Color = vbBlue \uc0c1\uae30 \uc0ac\ub840\ub294 Range \uac1c\uccb4\uc5d0 \uc801\uc6a9\ud55c \uac83\uc774\ub098 Cells \uac1c\uccb4\uc5d0\ub3c4 \uc544\ub798\uc640 \uac19\uc774 \uc801\uc6a9 \uac00\ub2a5\ud558\ub2e4. Cells(1, 2).Font.ColorIndex = 3 Cells(2, &#8220;B&#8221;).Font.Color &#8230; <a title=\"Excel VBA (Visual Basic for Applications) Color Index\" class=\"read-more\" href=\"https:\/\/i-kiin.net\/?page_id=5601\" aria-label=\"Excel VBA (Visual Basic for Applications) Color Index\uc5d0 \ub300\ud574 \ub354 \uc790\uc138\ud788 \uc54c\uc544\ubcf4\uc138\uc694\">\ub354 \uc77d\uae30<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":1539,"menu_order":6,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-5601","page","type-page","status-publish"],"_links":{"self":[{"href":"https:\/\/i-kiin.net\/index.php?rest_route=\/wp\/v2\/pages\/5601","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/i-kiin.net\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/i-kiin.net\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/i-kiin.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/i-kiin.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5601"}],"version-history":[{"count":0,"href":"https:\/\/i-kiin.net\/index.php?rest_route=\/wp\/v2\/pages\/5601\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/i-kiin.net\/index.php?rest_route=\/wp\/v2\/pages\/1539"}],"wp:attachment":[{"href":"https:\/\/i-kiin.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5601"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}