Icon SetCondition Properties

Name

Returns

Description

AppliesTo

Range

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

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

IconCriteria

IconCriteria

Read-only. Returns an IconCriteria collection, which is used to specify the thresholds of the criteria used in the formatting condition

IconSet

IconSets

Set/Get the specific built-in icon set used in the formatting condition

Name

Returns

Description

Percentile Values

Boolean

Set/Get whether the thresholds for an icon set conditional format are determined by using percentiles. Setting this property to True will ensure that all values are evaluated based on percentiles

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

ReverseOrder

Boolean

Set/Get whether the formatting rule should be applied in reverse order. For example, where low values are tagged as red, setting this property would tag low values as green

Condition

Scope

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

ShowIconOnly

Boolean

Setting this property to True ensures that only the icons will be displayed in the cell, as opposed to both the data and the icon

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. This object will always return a value of 12 since it corresponds to the xlAboveAverageCondition

0 0

Post a comment