Page 260 - Microsoft Office Excel 2003 Programming Inside Out

Microsoft Office Excel 2003 Programming Inside Out

Figure 10-2. AutoFormats make data labels stand out so your worksheet data is easier
to read.

You change the color and fill pattern of a cell by setting the properties of the Interior object,
which is referenced by the Interior property of a cell. Table 10-7 lists the properties of the
Interior object.
Table 10-7. The Interior Object’s Properties for Formatting a Cell
Property Description
Color Determines the fill color of the interior of a cell using an Excel color
constant or an RGB function value
ColorIndex Determines the fill color of the interior of a cell using an index value
Chapter 10
that refers to the Excel color palette
Pattern Determines the pattern used to fill the interior of a cell using one of
the XlPattern Excel constants: xlPatternAutomatic, xlPatternChecker,
xlPatternCrissCross, xlPatternDown, xlPatternGray16,
xlPatternGray25, xlPatternGray50, xlPatternGray75, xlPatternGray8,
xlPatternGrid, xlPatternHorizontal, xlPatternLightDown,
xlPatternLightHorizontal, xlPatternLightUp, xlPatternLightVertical,
xlPatternNone, xlPatternSemiGray75, xlPatternSolid, xlPatternUp, or
xlPatternVertical
PatternColor Determines the color of any fill pattern in the interior of a cell using
an Excel color constant or an RGB function value
PatternColorIndex Determines the color of any fill pattern in the interior of a cell using
an index value that refers to the Excel color palette

234
Part 4: Advanced VBA