DataBarConditionalFormatting Members
Represents a data bar conditional formatting rule.
#Properties
Name | Description |
---|---|
Axis |
Gets or sets the color of the axis between positive and negative bars. |
Axis |
Gets or sets the axis position in a cell. |
Border |
Gets or sets the data bar border color. |
Color | Gets or sets the color associated with data bars in the data bar conditional format. |
Direction | Gets or sets the direction of data bars. |
Gradient |
Gets or sets whether the gradient fill is applied to data bars. |
High |
Returns the Conditional |
Low |
Returns the Conditional |
Max |
Gets or sets the maximum length of the data bar, as a percentage of the cell width. |
Min |
Gets or sets the minimum length of the data bar, as a percentage of the cell width. |
Negative |
Gets or sets the negative bar border color. |
Negative |
Gets or sets the negative bar fill color. |
Priority |
Specifies the priority of the conditional formatting rule.
Inherited from Conditional |
Range |
Gets or sets the range of cells to which the conditional formatting rule is applied.
Inherited from Conditional |
Ranges |
Obsolete. Gets or sets a collection of ranges, to which the conditional format is applied.
Inherited from Conditional |
Show |
Indicates whether to show the values of cells to which the data bar conditional formatting rule is applied. |
Stop |
Specifies whether the rules with lower priority can be applied.
Inherited from Conditional |
See Also