NegativeBarFormat Object (Excel)

Office 2013 and later

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Represents the color settings of the data bars for negative values that are defined by a data bar conditional formating rule.

The properties of the NegativeBarFormat object can be used to specify the fill color and border of the data bars for negative values. Use the NegativeBarFormat of the Databar object that represents a data bar conditional formatting rule to access the NegativeBarFormat object associated with that rule.

© 2015 Microsoft