ErrorCheckingOptions.IndicatorColorIndex (Excel)

Returns or sets the color of the indicator for error checking options. Possible return values are xlColorIndexAutomatic - Automatic color, xlColorIndexNone - No color.

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.

Application.ErrorCheckingOptions.IndicatorColorIndex = xlColorIndexAutomatic