Databar Properties

Name

Returns

Description

AppliesTo

Range

Read-only. Returns the range that is affected by the formatting rule

BarColor

Format Color

Read-only. Returns the FormatColor object, which is used to specify the color of the bar shown

Formula

String

Set/Get a string representing a formula that determines the values that are to be evaluated in the conditional formatting rule

MaxPoint

Condition Value

Read-only. Returns the method by which the longest bar in the formatting rule is evaluated. Use the Type and Value properties of the ConditionValue

MinPoint

String

Read-only. Returns a ConditionValue object that can be used to specify the method by which the shortest bar in the formatting rule is evaluated

PercentMax

Long

Set/Get the length of the longest bar by using the cell width as a baseline. The value must be a whole number between 0 and 100

PercentMin

Long

Set/Get the length of the shortest bar by using the cell width as a baseline. The value must be a whole number between 0 and 100

Priority

Long

Set/Get the priority value of a conditional formatting rule, determining the order of evaluation when other rules are in effect

PTCondition

Boolean

Read-only. Indicates whether the formatting rule is applied to a PivotTable chart

ConditionScope

Set/Get the scope of the formatting rule when applied to a PivotTable chart. Use the xlPivotCondition-Scope constants

ShowValue

Boolean

If the ShowValue property is set to True, the actual value in the cell is displayed along with the data bar

StopifTrue

Boolean

Set/Get a Boolean value that determines if additional formatting rules should be applied if the current rule evaluates to True. The default value is True

Type

xlFormat ConditionType

Read-only. Returns an xlFormatConditionType constant, which specifies the type of conditional formatting being applied

0 0

Post a comment