Top Properties

Name

Returns

Description

AppliesTo

Range

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

Borders

Borders

Read-only. Returns a collection that specifies the cell borders for the formatting condition

CalcFor

xlCalcFor

Set/Get the scope of data to be evaluated in a PivotTable report. Use the xlCalcFor constant

Font

Font

Read-only. Specifies the font formatting attributes for the conditional formatting rule

FormatRow

Boolean

Set/Get the Boolean value specifying if the entire Excel table row should be formatted. The default value is False

Interior

Interior

Read-only. Specifies the Interior formatting attributes for the conditional formatting rule

NumberFormat

Variant

Set/Get the number format applied to a cell if the conditional formatting rule evaluates to true

Percent

Boolean

Set/Get whether the ranking of values within the given scope or range is determined by a percentage value

Priority

Long

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

Name

Returns

Description

PTCondition

Boolean

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

Rank

Long

Set/Get either the number or percentage rank value for the rule

Condition

Scope

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

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

TopBottom

xlTopBottom

Set/Get whether the ranking is evaluated from the top or the bottom. Use the xlTopBottom constants

Type

xlFormat ConditionType

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

0 0

Post a comment