ConditionalFormatRule

ConditionalFormatRule

Overview

ConditionalFormatRule is a interface in Aspose.Cells FOSS for TypeScript.

Properties: colorScale, dataBar, formula1, formula2, iconSet, operator, and 2 more.

Properties

NameTypeAccessDescription
type: "cellValue" | "expression" | "colorScale" | "iconSet" | "dataBar"ReadGets the type.
formula1: stringReadGets the formula1.
formula2: stringReadGets 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. |

See Also

 English