NegativeBarFormat.ColorType property (Excel)

Specifies whether to use the same fill color as positive data bars. Read/write.

Syntax

expression.ColorType

expression A variable that represents a NegativeBarFormat object.

Return value

XlDataBarNegativeColorType

Remarks

If you set the ColorType property to xlDataBarColor, use the Color property to return a FormatColor object that you can use to specify the fill color.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.