Microsoft Office Tutorials and References
In Depth Information
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
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
Search JabSto ::




Custom Search