@sheetkit/node / JsConditionalFormatRule
Interface: JsConditionalFormatRule
Defined in: packages/sheetkit/binding.d.ts:578
Conditional formatting rule configuration.
Properties
above?
optionalabove?:boolean
Defined in: packages/sheetkit/binding.d.ts:600
Whether rule is above average (for aboveAverage rules).
barColor?
optionalbarColor?:string
Defined in: packages/sheetkit/binding.d.ts:622
Data bar color (ARGB hex).
equalAverage?
optionalequalAverage?:boolean
Defined in: packages/sheetkit/binding.d.ts:602
Whether equal values count as matching (for aboveAverage rules).
format?
optionalformat?:JsConditionalStyle
Defined in: packages/sheetkit/binding.d.ts:626
Differential style to apply.
formula?
optionalformula?:string
Defined in: packages/sheetkit/binding.d.ts:590
First formula/value.
formula2?
optionalformula2?:string
Defined in: packages/sheetkit/binding.d.ts:592
Second formula/value (for between/notBetween).
maxColor?
optionalmaxColor?:string
Defined in: packages/sheetkit/binding.d.ts:620
Color scale maximum color (ARGB hex).
maxType?
optionalmaxType?:string
Defined in: packages/sheetkit/binding.d.ts:616
Color scale maximum value type.
maxValue?
optionalmaxValue?:string
Defined in: packages/sheetkit/binding.d.ts:618
Color scale maximum value.
midColor?
optionalmidColor?:string
Defined in: packages/sheetkit/binding.d.ts:614
Color scale middle color (ARGB hex).
midType?
optionalmidType?:string
Defined in: packages/sheetkit/binding.d.ts:610
Color scale middle value type.
midValue?
optionalmidValue?:string
Defined in: packages/sheetkit/binding.d.ts:612
Color scale middle value.
minColor?
optionalminColor?:string
Defined in: packages/sheetkit/binding.d.ts:608
Color scale minimum color (ARGB hex).
minType?
optionalminType?:string
Defined in: packages/sheetkit/binding.d.ts:604
Color scale minimum value type.
minValue?
optionalminValue?:string
Defined in: packages/sheetkit/binding.d.ts:606
Color scale minimum value.
operator?
optionaloperator?:string
Defined in: packages/sheetkit/binding.d.ts:588
Comparison operator for cellIs rules.
percent?
optionalpercent?:boolean
Defined in: packages/sheetkit/binding.d.ts:598
Whether rank is a percentage.
priority?
optionalpriority?:number
Defined in: packages/sheetkit/binding.d.ts:628
Rule priority (lower = higher precedence).
rank?
optionalrank?:number
Defined in: packages/sheetkit/binding.d.ts:596
Rank for top10/bottom10 rules.
ruleType
ruleType:
string
Defined in: packages/sheetkit/binding.d.ts:586
Rule type: "cellIs", "expression", "colorScale", "dataBar", "duplicateValues", "uniqueValues", "top10", "bottom10", "aboveAverage", "containsBlanks", "notContainsBlanks", "containsErrors", "notContainsErrors", "containsText", "notContainsText", "beginsWith", "endsWith".
showValue?
optionalshowValue?:boolean
Defined in: packages/sheetkit/binding.d.ts:624
Whether to show the cell value alongside the data bar.
stopIfTrue?
optionalstopIfTrue?:boolean
Defined in: packages/sheetkit/binding.d.ts:630
If true, no lower-priority rules apply when this matches.
text?
optionaltext?:string
Defined in: packages/sheetkit/binding.d.ts:594
Text for text-based rules.