XlCondFmtRuleDataBar Properties
Represents the Data Bar conditional formatting rule.| 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 color of the data bar borders. |
| Direction | Gets or sets the direction of data bars. |
| FillColor | Gets or sets the data bar fill color. |
| GradientFill | Gets or sets whether to apply the gradient fill type. |
| MaxLength | Gets or sets the maximum length of the data bar. |
| MaxValue | Provides access to the maximum value within the cells range to which the data bat formatting rule is applied. |
| MinLength | Gets or sets the minimum length of the data bar. |
| MinValue | Provides access to the minimum value within the cell range to which the data bar conditional formatting rule is applied. |
| NegativeBorderColor | Gets or sets the border color of a negative data bar. |
| NegativeFillColor | Gets or sets the color of a negative data bar. |
| Priority | Specifies the priority of the conditional formatting rule. Inherited from XlCondFmtRule. |
| RuleType | Gets the type of the specified conditional formatting rule. Inherited from XlCondFmtRule. |
| ShowValues | Gets or sets whether to display cell values to which the data bar conditional formatting rule is applied. |
| StopIfTrue | Gets or sets whether the conditional formatting rules with lower priority can be applied. Inherited from XlCondFmtRule. |
See Also