NegativeBarFormat Object (Excel)
Collapse the table of content
Expand the table of content
Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here. ArchiveDisclaimer

NegativeBarFormat Object (Excel)

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

Version Added: Excel 2010

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.

© 2016 Microsoft