ConditionalFormatRule
Overview
ConditionalFormatRule is a interface in Aspose.Cells FOSS for Typescript.
The ConditionalFormatRule class lets you define conditional formatting by specifying its type, formulas, operator, style, color scale, icon set, or data bar.
Properties: colorScale, dataBar, formula1, formula2, iconSet, operator, and 2 more.
Description
ConditionalFormatRule is an interface in Aspose.Cells FOSS for TypeScript that defines a contract with 0 methods. Classes that implement this interface must provide concrete implementations for all declared operations.
Core capabilities include: : "cellvalue" \; : string; : string`. These operations enable developers to integrate conditionalformatrule functionality directly into TypeScript applications.
The class also provides the type property (gets the type), the formula1 property (gets the formula1), the formula2 property (gets the formula2).
Properties
| Name | Type | Access | Description |
|---|---|---|---|
type | : "cellValue" | "expression" | "colorScale" | "iconSet" | "dataBar" | Read | Gets the type. |
formula1 | : string | Read | Gets the formula1. |
formula2 | : string | Read | Gets the formula2. |
operator | `: |
\| "between"
\| "notBetween"
\| "equal"
\| "notEqual"
\| "greaterThan"
\| "lessThan"
\| "greaterThanOrEqual"
\| "lessThanOrEqual"` | Read | Gets the operator. |
| style | : Style | Read | Gets the style. |
| colorScale | : ColorScaleRule | Read | Gets the color scale. |
| iconSet | : IconSetRule | Read | Gets the icon set. |
| dataBar | : DataBarRule | Read | Gets the data bar. |