ConditionalPresetCriteriaRule Object (JavaScript API for Excel)
Represents the Preset Criteria Conditional Format Rule
Properties
Property | Type | Description | Req. Set |
---|---|---|---|
criterion | string | The criterion of the conditional format. Possible values are: Invalid, Blanks, NonBlanks, Errors, NonErrors, Yesterday, Today, Tomorrow, LastSevenDays, LastWeek, ThisWeek, NextWeek, LastMonth, ThisMonth, NextMonth, AboveAverage, BelowAverage, EqualOrAboveAverage, EqualOrBelowAverage, OneStdDevAboveAverage, OneStdDevBelowAverage, TwoStdDevAboveAverage, TwoStdDevBelowAverage, ThreeStdDevAboveAverage, ThreeStdDevBelowAverage, UniqueValues, DuplicateValues. | 1.6 |
See property access examples.
Relationships
None
Methods
None