Color Scale Properties

Name

Returns

Description

AppliesTo

Range

Set/Get the range that is affected by the formatting rule

ColorScale

Criteria

Criteria

ColorScale

Returns a ColorScaleCriteria object, which is used to specify the type of scale to be used (two or three), the values that are to be evaluated, and the color of threshold criteria used. Read-only

FormatRow

Boolean

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

Formula

String

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

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 ConditionScope

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

lorScale Methods

Name

Parameters

Description

Delete

Deletes the object

ModifyApplies ToRange

Range As Range

Sets the range for which the formatting rule will be applied

SetFirstPriority

Sets the priority value for the formatting rule so that it is evaluated before all other rules on the worksheet

SetLastPriority

Sets the priority value for the formatting rule so that it is evaluated after all other rules on the worksheet

0 0

Post a comment