Edit

Excel.ConditionalFormatPresetCriterion enum

Package:
excel

Represents the criteria of the preset criteria conditional format type.

Remarks

[Api set: ExcelApi 1.6]

Fields

aboveAverage = "AboveAverage"
  • [Api set: ExcelApi 1.6]
belowAverage = "BelowAverage"
  • [Api set: ExcelApi 1.6]
blanks = "Blanks"
  • [Api set: ExcelApi 1.6]
duplicateValues = "DuplicateValues"
  • [Api set: ExcelApi 1.6]
equalOrAboveAverage = "EqualOrAboveAverage"
  • [Api set: ExcelApi 1.6]
equalOrBelowAverage = "EqualOrBelowAverage"
  • [Api set: ExcelApi 1.6]
errors = "Errors"
  • [Api set: ExcelApi 1.6]
invalid = "Invalid"
  • [Api set: ExcelApi 1.6]
lastMonth = "LastMonth"
  • [Api set: ExcelApi 1.6]
lastSevenDays = "LastSevenDays"
  • [Api set: ExcelApi 1.6]
lastWeek = "LastWeek"
  • [Api set: ExcelApi 1.6]
nextMonth = "NextMonth"
  • [Api set: ExcelApi 1.6]
nextWeek = "NextWeek"
  • [Api set: ExcelApi 1.6]
nonBlanks = "NonBlanks"
  • [Api set: ExcelApi 1.6]
nonErrors = "NonErrors"
  • [Api set: ExcelApi 1.6]
oneStdDevAboveAverage = "OneStdDevAboveAverage"
  • [Api set: ExcelApi 1.6]
oneStdDevBelowAverage = "OneStdDevBelowAverage"
  • [Api set: ExcelApi 1.6]
thisMonth = "ThisMonth"
  • [Api set: ExcelApi 1.6]
thisWeek = "ThisWeek"
  • [Api set: ExcelApi 1.6]
threeStdDevAboveAverage = "ThreeStdDevAboveAverage"
  • [Api set: ExcelApi 1.6]
threeStdDevBelowAverage = "ThreeStdDevBelowAverage"
  • [Api set: ExcelApi 1.6]
today = "Today"
  • [Api set: ExcelApi 1.6]
tomorrow = "Tomorrow"
  • [Api set: ExcelApi 1.6]
twoStdDevAboveAverage = "TwoStdDevAboveAverage"
  • [Api set: ExcelApi 1.6]
twoStdDevBelowAverage = "TwoStdDevBelowAverage"
  • [Api set: ExcelApi 1.6]
uniqueValues = "UniqueValues"
  • [Api set: ExcelApi 1.6]
yesterday = "Yesterday"
  • [Api set: ExcelApi 1.6]