Returns a WorkbookColorInfo which defines the border color applied to data bars with a negative value.

This property is only applicable when the barBorderColorType property is set to Color.

See

barBorderColorType

Returns or sets a DataBarNegativeBarColorType value which specifies whether the same border color as that which is used for data bars with positive cell values is also used for data bars with negative cell values.

By default, databars for cells with negative values use the same color as those with positive values, and the barBorderColor property is not used.

Use this property to apply the color specified by the barBorderColor property to the borders of databars with negative cell values.

See

• barBorderColor
• DataBarConditionalFormat.barBorderColor

Returns a WorkbookColorInfo which defines the fill color applied to data bars with a negative value.

This property is only applicable when the barColorType property is set to Color.

See

barBorderColorType

Returns or sets a DataBarNegativeBarColorType value which specifies whether the same color as that which is used for the positive data bars is used.

By default, databars for cells with negative values have a different color than those with positive values.

Use this property to apply the same color to databars regardless of whether the cell value is positive or negative.

See

• barColor
• DataBarConditionalFormat.barColor