It would be hard to compare the palettes between XL95 and XL97. In XL97/XL2000 VBE HELP (Alt+F11, F1) -> index -> ColorIndex property
In XL95 Help -> index -> Colorindex property To see your 56 colors (to bring up box in VBA) My system even after resetting colors (Tools -> Options). Color6 and Color27 appear to both be Yellow on I have had to change some colors to match Microsoft usage from what More confusion found in MS KB documentationĠ - Black, 1 - Blue, 2 - Green, 3 - Cyan, 4 - Red, 5 - Magenta, 6 - Yellow/Brown, 7 - White,ĩ - Bright Blue, A - Bright Green, B - Bright Cyan, C - Bright Red, D - Bright Magenta, E - Bright Yellow, F - Bright White The following colors has been used in Microsoft KB documentation probably for the first 16 colors: The RGB values definitely match color swatches.Ĭolors appears to have a wide variance I am trying to find what Microsoft generally calls them if they are not named in Excel. Correct interpretation of the 56 colors in the ColorIndex is dependent upon the HTML wizard conversion on ColorIndex numbers. Note: I have not had any desire to change my own colors so expect them to be unchanged. You can also replace the default color palette that Microsoft ExcelĬopy color palettes between workbooks (#copy)ġ Open the workbook that contains the color palette you want to copy.Ģ Switch to the workbook to which you want to copy the color palette.ģ On the Tools menu, click Options, and then click the Color tab.Ĥ In the Copy Colors From box, click the workbook that contains the color palette you want to copy. For example, you can create a customĬolor palette that matches your company’s logo and image and thenĬopy it into the workbooks used in company presentations. Scheme in a set of workbooks, you can copy the color palette from When you change a color in the palette, it isĬhanged for any element formatted with the color you changed, If you are using a color monitor, you canĬustomize the shade and intensity of the colors in the color palette The arrangement in XL97 differs from previous releases in that the colors are arranged from darker to lighter colors, but the Color Index values remain the same.Įach Microsoft Excel workbook has a palette of 56 colors that youĬan apply to cells, fonts, gridlines, graphic objects, and fills and To change the default,Ĭhange your book.xlt template for new workbooks.
Scope of the Color Palette: Each workbook has it’s own palette.
Please refer to Install a Macro or User Defined Function on my Formula page. If you need assistance to installing either This page contains some VBA macros and User Defined Functions. Keywords: color, colorindex, colors, colour, colours, paletteĮxcel Color Index, coloring of fonts, cell interiors ,
0 kommentar(er)
