ID: Q179003
The information in this article applies to:
In Microsoft Excel 98 Macintosh Edition, when you select a color from the color palette, the value of the Microsoft Visual Basic for Applications ColorIndex property of the color you select may not be what you expect.
This occurs in Microsoft Excel 98 Macintosh Edition because colors within the color palette are sorted chromatically, not by color index. This behavior is different than in earlier versions of Microsoft Excel for the Macintosh.
This behavior is by design of Microsoft Excel 98 Macintosh Edition.
In Microsoft Excel, you can view the color palette by clicking the drop- down arrow just to the right of the Font Color button on the Formatting toolbar.
In Microsoft Excel version 5.0, colors are arranged on the color palette by color index. The first row of colors contains colors 1 through 8, the second row contains colors 9 through 16, and so on.
In Microsoft Excel 97 for Windows and Excel 98 Macintosh Edition, colors are arranged on the color palette in chromatic order. The first row contains the eight darkest colors, the second row is lighter than the first, and so on to the last row, which contains the eight lightest colors.
The ColorIndex property values have not changed, however, so Visual Basic code that changes the color of fonts or cell backgrounds should work exactly the same in Microsoft Excel 98 Macintosh Edition as it does in earlier versions of Microsoft Excel.
For additional information, please see the following article in the Microsoft Knowledge Base:
ARTICLE-ID: Q192906
TITLE : XL: Sample Visual Basic Code to Create Color Index Table
For more information about the ColorIndex property, click the Office Assistant in the Visual Basic Editor, type "ColorIndex", click Search, and then click to view "ColorIndex Property".
Additional query words: XL98 indexes indices
Keywords : kbprg kbui
Platform : MACINTOSHLast Reviewed: May 24, 1999