IronCalc Node.js
    Preparing search index...

    Type Alias CfRuleInput

    CfRuleInput:
        | { thresholds: ColorScaleThreshold[]; type: "ColorScale" }
        | {
            format: Dxf;
            formula: string;
            formula2: string | null;
            operator: ValueOperator;
            stop_if_true: boolean;
            type: "CellIs";
        }
        | { format: Dxf; formula: string; stop_if_true: boolean; type: "Formula" }
        | {
            format: Dxf;
            operator: TextOperator;
            stop_if_true: boolean;
            type: "Text";
            value: string;
        }
        | {
            date1: string
            | null;
            date2: string | null;
            format: Dxf;
            stop_if_true: boolean;
            time_period: PeriodType;
            type: "TimePeriod";
        }
        | { format: Dxf; stop_if_true: boolean; type: "DuplicateValues" }
        | { format: Dxf; stop_if_true: boolean; type: "UniqueValues" }
        | { format: Dxf; stop_if_true: boolean; type: "Blanks" }
        | { format: Dxf; stop_if_true: boolean; type: "NotBlanks" }
        | { format: Dxf; stop_if_true: boolean; type: "Errors" }
        | { format: Dxf; stop_if_true: boolean; type: "NoErrors" }
        | { format: Dxf; stop_if_true: boolean; type: "AboveAverage" }
        | { format: Dxf; stop_if_true: boolean; type: "BelowAverage" }
        | {
            format: Dxf;
            percent: boolean;
            rank: number;
            stop_if_true: boolean;
            type: "Top10";
        }
        | {
            format: Dxf;
            percent: boolean;
            rank: number;
            stop_if_true: boolean;
            type: "Bottom10";
        }
        | {
            is_gradient: boolean;
            max: Cfvo
            | null;
            min: Cfvo | null;
            negative_color: Color;
            positive_color: Color;
            show_value: boolean;
            type: "DataBar";
        }
        | { show_value: boolean; thresholds: IconThreshold[]; type: "IconSet" }
        | {
            color: Color;
            icon: Icon;
            show_value: boolean;
            thresholds: [Cfvo, boolean][];
            type: "IconRating";
        }

    Input CF rule for addConditionalFormatting / updateConditionalFormatting. Dxf-based variants carry an inline format and a stop_if_true flag.