Enumeration: RuleType

Sheets.ConditionalFormatting.RuleType

Specifies the rule type.

Table of contents

Enumeration members

• averageRule
• cellValueRule
• columnStateRule
• conditionRuleBase
• dataBarRule
• dateOccurringRule
• duplicateRule
• formulaRule
• iconSetRule
• rowStateRule
• specificTextRule
• threeScaleRule
• top10Rule
• twoScaleRule
• uniqueRule

Enumeration members

averageRule

• averageRule = 8

Specifies the average rule.

cellValueRule

• cellValueRule = 1

Specifies the cell value rule.

columnStateRule

• columnStateRule = 15

Specifies the column state rule.

conditionRuleBase

• conditionRuleBase = 0

Specifies the base rule of the condition.

dataBarRule

• dataBarRule = 12

Specifies the data bar rule.

dateOccurringRule

• dateOccurringRule = 4

Specifies the date occurring rule.

duplicateRule

• duplicateRule = 7

Specifies the duplicate rule.

formulaRule

• formulaRule = 3

Specifies the formula rule.

iconSetRule

• iconSetRule = 13

Specifies the icon set rule.

rowStateRule

• rowStateRule = 14

Specifies the row state rule.

specificTextRule

• specificTextRule = 2

Specifies the specific text rule.

threeScaleRule

• threeScaleRule = 11

Specifies the three scale rule.

top10Rule

• top10Rule = 5

Specifies the top 10 rule.

twoScaleRule

• twoScaleRule = 10

Specifies the two scale rule.

uniqueRule

• uniqueRule = 6

Specifies the unique rule.