DataBarConditionalFormatting Members
Represents a data bar conditional formatting rule.Properties
| Name | Description |
|---|---|
| AxisColor | Gets or sets the color of the axis between positive and negative bars. |
| AxisPosition | Gets or sets the axis position in a cell. |
| BorderColor | 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. |
| GradientFill | Gets or sets whether the gradient fill is applied to data bars. |
| HighBound | Returns the ConditionalFormattingValue object that specifies how the longest bar is evaluated for the data bar conditional format. |
| LowBound | Returns the ConditionalFormattingValue object that specifies how the shortest bar is evaluated for the data bar conditional format. |
| MaxLength | Gets or sets the maximum length of the data bar, as a percentage of the cell width. |
| MinLength | Gets or sets the minimum length of the data bar, as a percentage of the cell width. |
| NegativeBarBorderColor | Gets or sets the negative bar border color. |
| NegativeBarColor | Gets or sets the negative bar fill color. |
| Priority | Specifies the priority of the conditional formatting rule. Inherited from ConditionalFormatting. |
| Range | Gets or sets the range of cells to which the conditional formatting rule is applied. Inherited from ConditionalFormatting. |
| Ranges | Obsolete. Gets or sets a collection of ranges, to which the conditional format is applied. Inherited from ConditionalFormatting. |
| ShowValue | Indicates whether to show the values of cells to which the data bar conditional formatting rule is applied. |
| StopIfTrue | Specifies whether the rules with lower priority can be applied. Inherited from ConditionalFormatting. |
See Also