Syntax

expression.IndicatorColorIndex

expression A variable that represents an ErrorCheckingOptions object.

Remarks

XlColorIndex can be one of these XlColorIndex constants.
xlColorIndexAutomatic The default system color.
xlColorIndexNone Not used with this property.

You can specify a particular color for the indicator by entering the corresponding index value. You can use the Colors property to return the current color palette.

Example

In the following example, Microsoft Excel checks to see if the indicator color for error checking is set to the default system color and notifies the user accordingly.

Visual Basic for Applications 
Sub CheckIndexColor() If Application.ErrorCheckingOptions.IndicatorColorIndex = xlColorIndexAutomatic Then MsgBox "Your indicator color for error checking is set to the default system color." Else MsgBox "Your indicator color for error checking is not set to the default system color." End If End Sub
INDICATOR indicator color index indicatorcolor indicatorcolorindex indicatorcolorindex property

See also: