Above Average Properties

Name

Returns

Description

AboveBelow

xlAboveBelow

Set/Get the conditional formatting rule looking for values above or below the average. Use the xlAboveBelow constants

AppliesTo

Range

Set/Get 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

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

ScopeType Condition Scope

xlPivot

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

Type

ConditionType

xlFormat

Read-only. Returns an xlFormatConditionType constant that specifies the type of conditional formatting being applied. This object will always return a value of 12 since it corresponds to the XlAboveAverageCondition

0 0

Post a comment