Conditional formatting

[Apkawa]

Conditional Formats

ST_CfType

• cellIs Conditional Format Operators

• expression

• colorScale

• dataBar

• iconSet

• top10

• uniqueValues

• duplicateValues

• containsText

• notContainsText

• beginsWith

• endsWith

• containsBlanks

• notContainsBlanks

• containsErrors

• notContainsErrors

• timePeriod

• aboveAverage

• Resolve formula in anywhere conditions:
  Maybe use https://github.com/bradbase/xlcalculator

  • Expression like A1>0
  • Expression like MIN(A1:B10)
  • Refererence to another sheet like #Sheet 2!A1