Class ColorFormat (Excel VBA)

The class ColorFormat represents the color of a one-color object, the foreground or background color of an object with a gradient or patterned fill, or the pointer color.


Returns or sets the luminosity of the specified object.

The value for this property must be a number from 0.0 (dimmest) to 1.0 (brightest).

ActiveSheet.Shapes(1).Fill.ForeColor.Brightness = 0.5


Returns or sets a color that is mapped to the theme color scheme.


Returns the parent object for the specified object. Read-only.


Returns or sets a Long value that represents the red-green-blue value of the specified color.


Returns or sets an Integer value that represents the color of a Color object, as an index in the current color.


Returns or sets a Single that lightens or darkens a color.

You can enter a number from -1 (darkest) to 1 (lightest) for the TintAndShade property. Zero (0) is neutral. Attempting to set this property to a value less than -1 or more than 1 results in a run-time error: "The specified value is out of range." This property works for both theme colors and nontheme colors.


Returns an MsoColorType value that represents the color format type.