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

Was this article helpful?

0 0
The Accidental Blogging Millionaires

The Accidental Blogging Millionaires

Get Inspired By The Most Popular Bloggers Online! If You Want To Skyrocket Your Success With Business And Improve Your Overall Life You Need To Have A Look At The Accidental Blogging Millionaires! Business can be a fight, particularly when you’re trying to establish one online and like all fights, to succeed you must find the winning techniques and apply them.

Get My Free Ebook


Post a comment