Skip to main content

XlCondFmtRuleDataBar Members

Represents the Data Bar conditional formatting rule.

Constructors

Name Description
XlCondFmtRuleDataBar() Initializes a new instance of the XlCondFmtRuleDataBar class with the default settings.

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 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.

Methods

Name Description
Equals(Object, Object) static Determines whether the specified object instances are considered equal. Inherited from Object.
Equals(Object) Determines whether the specified object is equal to the current object. Inherited from Object.
GetHashCode() Serves as the default hash function. Inherited from Object.
GetType() Gets the Type of the current instance. Inherited from Object.
MemberwiseClone() protected Creates a shallow copy of the current Object. Inherited from Object.
ReferenceEquals(Object, Object) static Determines whether the specified Object instances are the same instance. Inherited from Object.
ToString() Returns a string that represents the current object. Inherited from Object.
See Also