Name | Description | |
---|---|---|
![]() | AppliesTo | Returns a Range object that specifies the cell range to which the formatting rule is applied. |
![]() | AxisColor | Gets the color of the axis for cells with conditional formatting as data bars. |
![]() | AxisPosition | Gets or sets the position of the axis of the data bars specified by a conditional formatting rule. |
![]() | BarBorder | Gets an object that specifies the border of a data bar. |
![]() | BarColor | Returns a FormatColor object that you can use to modify the color of the bars in a data bar conditional format. |
![]() | BarFillType | Gets or sets how a data bar is filled with color. |
![]() | Direction | Gets or sets the direction the data bar is displayed. |
![]() | MaxPoint | Returns a IConditionValue object that specifies how the longest bar is evaluated for a data bar conditional format. |
![]() | MinPoint | Returns a ConditionValue object that specifies how the shortest bar is evaluated for a data bar conditional format. |
![]() | NegativeBarFormat | Gets the NegativeBarFormat object associated with a data bar conditional formatting rule. |
![]() | PercentMax | Returns or sets an Integer value that specifies the length of the longest data bar as a percentage of cell width. |
![]() | PercentMin | Returns or sets an Integer value that specifies the length of the shortest data bar as a percentage of cell width. |
![]() | Priority | Returns or sets the priority value of the conditional formatting rule. The priority determines the order of evaluation when multiple conditional formatting rules exist in a worksheet. |
![]() | ShowValue | Returns or sets a Boolean value that specifies if the value in the cell is displayed if the data bar conditional format is applied to the range. |
![]() | StopIfTrue | Returns or sets a Boolean value that determines if additional formatting rules on the cell should be evaluated if the current rule evaluates to True. |
![]() | Type | Returns the type of this conditional format. |