VBA中的ColorIndex信息

分手后的思念是犯贱 2021-11-22 03:20 218阅读 0赞

<table> 
 <tbody> 
 <tr> 
 <td>interior</td> 
 <td>font</td> 
 <td><a href="http://www.mvps.org/dmcritchie/excel/colors.htm#hexconvxl" rel="nofollow">HTML</a></td> 
 <td>bgcolor=</td> 
 <td align="right"><a href="http://www.mvps.org/dmcritchie/excel/colors.htm#hexconv" rel="nofollow">Red</a>&lt;</td> 
 <td align="right">Green</td> 
 <td align="right">Blue</td> 
 <td>Color</td> 
 </tr> 
 <tr> 
 <td>Black</td> 
 <td>[Color 1]</td> 
 <td>#000000</td> 
 <td>#000000</td> 
 <td align="right">0</td> 
 <td align="right">0</td> 
 <td align="right">0</td> 
 <td>[Black]</td> 
 </tr> 
 <tr> 
 <td>White</td> 
 <td>[Color 2]</td> 
 <td>#FFFFFF</td> 
 <td>#FFFFFF</td> 
 <td align="right">255</td> 
 <td align="right">255</td> 
 <td align="right">255</td> 
 <td>[White]</td> 
 </tr> 
 <tr> 
 <td>Red</td> 
 <td>[Color 3]</td> 
 <td>#FF0000</td> 
 <td>#FF0000</td> 
 <td align="right">255</td> 
 <td align="right">0</td> 
 <td align="right">0</td> 
 <td>[Red]</td> 
 </tr> 
 <tr> 
 <td>Green</td> 
 <td>[Color 4]</td> 
 <td>#00FF00</td> 
 <td>#00FF00</td> 
 <td align="right">0</td> 
 <td align="right">255</td> 
 <td align="right">0</td> 
 <td>[Green]</td> 
 </tr> 
 <tr> 
 <td>Blue</td> 
 <td>[Color 5]</td> 
 <td>#0000FF</td> 
 <td>#0000FF</td> 
 <td align="right">0</td> 
 <td align="right">0</td> 
 <td align="right">255</td> 
 <td>[Blue]</td> 
 </tr> 
 <tr> 
 <td>Yellow</td> 
 <td>[Color 6]</td> 
 <td>#FFFF00</td> 
 <td>#FFFF00</td> 
 <td align="right">255</td> 
 <td align="right">255</td> 
 <td align="right">0</td> 
 <td>[Yellow]</td> 
 </tr> 
 <tr> 
 <td>Magenta</td> 
 <td>[Color 7]</td> 
 <td>#FF00FF</td> 
 <td>#FF00FF</td> 
 <td align="right">255</td> 
 <td align="right">0</td> 
 <td align="right">255</td> 
 <td>[Magenta]</td> 
 </tr> 
 <tr> 
 <td>Cyan</td> 
 <td>[Color 8]</td> 
 <td>#00FFFF</td> 
 <td>#00FFFF</td> 
 <td align="right">0</td> 
 <td align="right">255</td> 
 <td align="right">255</td> 
 <td>[Cyan]</td> 
 </tr> 
 <tr> 
 <td>[Color 9]</td> 
 <td>[Color 9]</td> 
 <td>#800000</td> 
 <td>#800000</td> 
 <td align="right">128</td> 
 <td align="right">0</td> 
 <td align="right">0</td> 
 <td>[Color 9]</td> 
 </tr> 
 <tr> 
 <td>[Color 10]</td> 
 <td>[Color 10]</td> 
 <td>#008000</td> 
 <td>#008000</td> 
 <td align="right">0</td> 
 <td align="right">128</td> 
 <td align="right">0</td> 
 <td>[Color 10]</td> 
 </tr> 
 <tr> 
 <td>[Color 11]</td> 
 <td>[Color 11]</td> 
 <td>#000080</td> 
 <td>#000080</td> 
 <td align="right">0</td> 
 <td align="right">0</td> 
 <td align="right">128</td> 
 <td>[Color 11]</td> 
 </tr> 
 <tr> 
 <td>[Color 12]</td> 
 <td>[Color 12]</td> 
 <td>#808000</td> 
 <td>#808000</td> 
 <td align="right">128</td> 
 <td align="right">128</td> 
 <td align="right">0</td> 
 <td>[Color 12]</td> 
 </tr> 
 <tr> 
 <td>[Color 13]</td> 
 <td>[Color 13]</td> 
 <td>#800080</td> 
 <td>#800080</td> 
 <td align="right">128</td> 
 <td align="right">0</td> 
 <td align="right">128</td> 
 <td>[Color 13]</td> 
 </tr> 
 <tr> 
 <td>[Color 14]</td> 
 <td>[Color 14]</td> 
 <td>#008080</td> 
 <td>#008080</td> 
 <td align="right">0</td> 
 <td align="right">128</td> 
 <td align="right">128</td> 
 <td>[Color 14]</td> 
 </tr> 
 <tr> 
 <td>[Color 15]</td> 
 <td>[Color 15]</td> 
 <td>#C0C0C0</td> 
 <td>#C0C0C0</td> 
 <td align="right">192</td> 
 <td align="right">192</td> 
 <td align="right">192</td> 
 <td>[Color 15]</td> 
 </tr> 
 <tr> 
 <td>[Color 16]</td> 
 <td>[Color 16]</td> 
 <td>#808080</td> 
 <td>#808080</td> 
 <td align="right">128</td> 
 <td align="right">128</td> 
 <td align="right">128</td> 
 <td>[Color 16]</td> 
 </tr> 
 <tr> 
 <td>[Color 17]</td> 
 <td>[Color 17]</td> 
 <td>#9999FF</td> 
 <td>#9999FF</td> 
 <td align="right">153</td> 
 <td align="right">153</td> 
 <td align="right">255</td> 
 <td>[Color 17]</td> 
 </tr> 
 <tr> 
 <td>[Color 18]</td> 
 <td>[Color 18]</td> 
 <td>#993366</td> 
 <td>#993366</td> 
 <td align="right">153</td> 
 <td align="right">51</td> 
 <td align="right">102</td> 
 <td>[Color 18]</td> 
 </tr> 
 <tr> 
 <td>[Color 19]</td> 
 <td>[Color 19]</td> 
 <td>#FFFFCC</td> 
 <td>#FFFFCC</td> 
 <td align="right">255</td> 
 <td align="right">255</td> 
 <td align="right">204</td> 
 <td>[Color 19]</td> 
 </tr> 
 <tr> 
 <td>[Color 20]</td> 
 <td>[Color 20]</td> 
 <td>#CCFFFF</td> 
 <td>#CCFFFF</td> 
 <td align="right">204</td> 
 <td align="right">255</td> 
 <td align="right">255</td> 
 <td>[Color 20]</td> 
 </tr> 
 <tr> 
 <td>[Color 21]</td> 
 <td>[Color 21]</td> 
 <td>#660066</td> 
 <td>#660066</td> 
 <td align="right">102</td> 
 <td align="right">0</td> 
 <td align="right">102</td> 
 <td>[Color 21]</td> 
 </tr> 
 <tr> 
 <td>[Color 22]</td> 
 <td>[Color 22]</td> 
 <td>#FF8080</td> 
 <td>#FF8080</td> 
 <td align="right">255</td> 
 <td align="right">128</td> 
 <td align="right">128</td> 
 <td>[Color 22]</td> 
 </tr> 
 <tr> 
 <td>[Color 23]</td> 
 <td>[Color 23]</td> 
 <td>#0066CC</td> 
 <td>#0066CC</td> 
 <td align="right">0</td> 
 <td align="right">102</td> 
 <td align="right">204</td> 
 <td>[Color 23]</td> 
 </tr> 
 <tr> 
 <td>[Color 24]</td> 
 <td>[Color 24]</td> 
 <td>#CCCCFF</td> 
 <td>#CCCCFF</td> 
 <td align="right">204</td> 
 <td align="right">204</td> 
 <td align="right">255</td> 
 <td>[Color 24]</td> 
 </tr> 
 <tr> 
 <td>[Color 25]</td> 
 <td>[Color 25]</td> 
 <td>#000080</td> 
 <td>#000080</td> 
 <td align="right">0</td> 
 <td align="right">0</td> 
 <td align="right">128</td> 
 <td>[Color 25]</td> 
 </tr> 
 <tr> 
 <td>[Color 26]</td> 
 <td>[Color 26]</td> 
 <td>#FF00FF</td> 
 <td>#FF00FF</td> 
 <td align="right">255</td> 
 <td align="right">0</td> 
 <td align="right">255</td> 
 <td>[Color 26]</td> 
 </tr> 
 <tr> 
 <td>[Color 27]</td> 
 <td>[Color 27]</td> 
 <td>#FFFF00</td> 
 <td>#FFFF00</td> 
 <td align="right">255</td> 
 <td align="right">255</td> 
 <td align="right">0</td> 
 <td>[Color 27]</td> 
 </tr> 
 <tr> 
 <td>[Color 28]</td> 
 <td>[Color 28]</td> 
 <td>#00FFFF</td> 
 <td>#00FFFF</td> 
 <td align="right">0</td> 
 <td align="right">255</td> 
 <td align="right">255</td> 
 <td>[Color 28]</td> 
 </tr> 
 <tr> 
 <td>[Color 29]</td> 
 <td>[Color 29]</td> 
 <td>#800080</td> 
 <td>#800080</td> 
 <td align="right">128</td> 
 <td align="right">0</td> 
 <td align="right">128</td> 
 <td>[Color 29]</td> 
 </tr> 
 <tr> 
 <td>[Color 30]</td> 
 <td>[Color 30]</td> 
 <td>#800000</td> 
 <td>#800000</td> 
 <td align="right">128</td> 
 <td align="right">0</td> 
 <td align="right">0</td> 
 <td>[Color 30]</td> 
 </tr> 
 <tr> 
 <td>[Color 31]</td> 
 <td>[Color 31]</td> 
 <td>#008080</td> 
 <td>#008080</td> 
 <td align="right">0</td> 
 <td align="right">128</td> 
 <td align="right">128</td> 
 <td>[Color 31]</td> 
 </tr> 
 <tr> 
 <td>[Color 32]</td> 
 <td>[Color 32]</td> 
 <td>#0000FF</td> 
 <td>#0000FF</td> 
 <td align="right">0</td> 
 <td align="right">0</td> 
 <td align="right">255</td> 
 <td>[Color 32]</td> 
 </tr> 
 <tr> 
 <td>[Color 33]</td> 
 <td>[Color 33]</td> 
 <td>#00CCFF</td> 
 <td>#00CCFF</td> 
 <td align="right">0</td> 
 <td align="right">204</td> 
 <td align="right">255</td> 
 <td>[Color 33]</td> 
 </tr> 
 <tr> 
 <td>[Color 34]</td> 
 <td>[Color 34]</td> 
 <td>#CCFFFF</td> 
 <td>#CCFFFF</td> 
 <td align="right">204</td> 
 <td align="right">255</td> 
 <td align="right">255</td> 
 <td>[Color 34]</td> 
 </tr> 
 <tr> 
 <td>[Color 35]</td> 
 <td>[Color 35]</td> 
 <td>#CCFFCC</td> 
 <td>#CCFFCC</td> 
 <td align="right">204</td> 
 <td align="right">255</td> 
 <td align="right">204</td> 
 <td>[Color 35]</td> 
 </tr> 
 <tr> 
 <td>[Color 36]</td> 
 <td>[Color 36]</td> 
 <td>#FFFF99</td> 
 <td>#FFFF99</td> 
 <td align="right">255</td> 
 <td align="right">255</td> 
 <td align="right">153</td> 
 <td>[Color 36]</td> 
 </tr> 
 <tr> 
 <td>[Color 37]</td> 
 <td>[Color 37]</td> 
 <td>#99CCFF</td> 
 <td>#99CCFF</td> 
 <td align="right">153</td> 
 <td align="right">204</td> 
 <td align="right">255</td> 
 <td>[Color 37]</td> 
 </tr> 
 <tr> 
 <td>[Color 38]</td> 
 <td>[Color 38]</td> 
 <td>#FF99CC</td> 
 <td>#FF99CC</td> 
 <td align="right">255</td> 
 <td align="right">153</td> 
 <td align="right">204</td> 
 <td>[Color 38]</td> 
 </tr> 
 <tr> 
 <td>[Color 39]</td> 
 <td>[Color 39]</td> 
 <td>#CC99FF</td> 
 <td>#CC99FF</td> 
 <td align="right">204</td> 
 <td align="right">153</td> 
 <td align="right">255</td> 
 <td>[Color 39]</td> 
 </tr> 
 <tr> 
 <td>[Color 40]</td> 
 <td>[Color 40]</td> 
 <td>#FFCC99</td> 
 <td>#FFCC99</td> 
 <td align="right">255</td> 
 <td align="right">204</td> 
 <td align="right">153</td> 
 <td>[Color 40]</td> 
 </tr> 
 <tr> 
 <td>[Color 41]</td> 
 <td>[Color 41]</td> 
 <td>#3366FF</td> 
 <td>#3366FF</td> 
 <td align="right">51</td> 
 <td align="right">102</td> 
 <td align="right">255</td> 
 <td>[Color 41]</td> 
 </tr> 
 <tr> 
 <td>[Color 42]</td> 
 <td>[Color 42]</td> 
 <td>#33CCCC</td> 
 <td>#33CCCC</td> 
 <td align="right">51</td> 
 <td align="right">204</td> 
 <td align="right">204</td> 
 <td>[Color 42]</td> 
 </tr> 
 <tr> 
 <td>[Color 43]</td> 
 <td>[Color 43]</td> 
 <td>#99CC00</td> 
 <td>#99CC00</td> 
 <td align="right">153</td> 
 <td align="right">204</td> 
 <td align="right">0</td> 
 <td>[Color 43]</td> 
 </tr> 
 <tr> 
 <td>[Color 44]</td> 
 <td>[Color 44]</td> 
 <td>#FFCC00</td> 
 <td>#FFCC00</td> 
 <td align="right">255</td> 
 <td align="right">204</td> 
 <td align="right">0</td> 
 <td>[Color 44]</td> 
 </tr> 
 <tr> 
 <td>[Color 45]</td> 
 <td>[Color 45]</td> 
 <td>#FF9900</td> 
 <td>#FF9900</td> 
 <td align="right">255</td> 
 <td align="right">153</td> 
 <td align="right">0</td> 
 <td>[Color 45]</td> 
 </tr> 
 <tr> 
 <td>[Color 46]</td> 
 <td>[Color 46]</td> 
 <td>#FF6600</td> 
 <td>#FF6600</td> 
 <td align="right">255</td> 
 <td align="right">102</td> 
 <td align="right">0</td> 
 <td>[Color 46]</td> 
 </tr> 
 <tr> 
 <td>[Color 47]</td> 
 <td>[Color 47]</td> 
 <td>#666699</td> 
 <td>#666699</td> 
 <td align="right">102</td> 
 <td align="right">102</td> 
 <td align="right">153</td> 
 <td>[Color 47]</td> 
 </tr> 
 <tr> 
 <td>[Color 48]</td> 
 <td>[Color 48]</td> 
 <td>#969696</td> 
 <td>#969696</td> 
 <td align="right">150</td> 
 <td align="right">150</td> 
 <td align="right">150</td> 
 <td>[Color 48]</td> 
 </tr> 
 <tr> 
 <td>[Color 49]</td> 
 <td>[Color 49]</td> 
 <td>#003366</td> 
 <td>#003366</td> 
 <td align="right">0</td> 
 <td align="right">51</td> 
 <td align="right">102</td> 
 <td>[Color 49]</td> 
 </tr> 
 <tr> 
 <td>[Color 50]</td> 
 <td>[Color 50]</td> 
 <td>#339966</td> 
 <td>#339966</td> 
 <td align="right">51</td> 
 <td align="right">153</td> 
 <td align="right">102</td> 
 <td>[Color 50]</td> 
 </tr> 
 <tr> 
 <td>[Color 51]</td> 
 <td>[Color 51]</td> 
 <td>#003300</td> 
 <td>#003300</td> 
 <td align="right">0</td> 
 <td align="right">51</td> 
 <td align="right">0</td> 
 <td>[Color 51]</td> 
 </tr> 
 <tr> 
 <td>[Color 52]</td> 
 <td>[Color 52]</td> 
 <td>#333300</td> 
 <td>#333300</td> 
 <td align="right">51</td> 
 <td align="right">51</td> 
 <td align="right">0</td> 
 <td>[Color 52]</td> 
 </tr> 
 <tr> 
 <td>[Color 53]</td> 
 <td>[Color 53]</td> 
 <td>#993300</td> 
 <td>#993300</td> 
 <td align="right">153</td> 
 <td align="right">51</td> 
 <td align="right">0</td> 
 <td>[Color 53]</td> 
 </tr> 
 <tr> 
 <td>[Color 54]</td> 
 <td>[Color 54]</td> 
 <td>#993366</td> 
 <td>#993366</td> 
 <td align="right">153</td> 
 <td align="right">51</td> 
 <td align="right">102</td> 
 <td>[Color 54]</td> 
 </tr> 
 <tr> 
 <td>[Color 55]</td> 
 <td>[Color 55]</td> 
 <td>#333399</td> 
 <td>#333399</td> 
 <td align="right">51</td> 
 <td align="right">51</td> 
 <td align="right">153</td> 
 <td>[Color 55]</td> 
 </tr> 
 <tr> 
 <td>[Color 56]</td> 
 <td>[Color 56]</td> 
 <td>#333333</td> 
 <td>#333333</td> 
 <td align="right">51</td> 
 <td align="right">51</td> 
 <td align="right">51</td> 
 <td>[Color 56]</td> 
 </tr> 
 <tr> 
 <td colspan="8">Excel only recognizes names for Color 1 through 8 (Black, White, Red, Green, Blue, Yellow, Magenta, and Cyan).&nbsp; The colors 1-16 are widely understood color names from the VGA color palette.&nbsp; Of the 56 colors only 40 colors appear on the palette.&nbsp; The 40 colors names indicated on the Excel color palette (see <a href="http://www.mvps.org/dmcritchie/excel/colors.htm#dpalette" rel="nofollow">below</a>) are for descriptive purposes only.&nbsp; </td> 
 </tr> 
 </tbody> 
</table>

The following color pairs are the same color  
  11 & 25,  5 & 32,  14 & 31,  8 & 28,  9 & 30, 13 & 29,  18 & 54, 20 &34,  7 & 26,  and   6 & 27.

转载于:https://www.cnblogs.com/lx0831/archive/2009/01/16/1377048.html