NegativeBarFormat Members (Excel)

GitHub-Mark-64px

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.

Name

Description

Application

When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object. Read-only.

BorderColor

Returns a FormatColor object that you can use to specify the border color for negative data bars. Read-only

BorderColorType

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

Color

Returns a FormatColor object that you can use to specify the fill color for negative data bars. Read-only

ColorType

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

Creator

Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.

Parent

Returns the parent object for the specified object. Read-only.

Show: