Interface PivotConditionalFormatJSON

A conditional format of a pivot table: a sheet rule, by priority, and the areas it applies to.

interface PivotConditionalFormatJSON {
    areas: PivotAreaJSON[];
    priority: number;
    scope?: string;
    type?: string;
}

Properties

priority: number

The sheet rule's priority, as read.

scope?: string

What the areas select, as OOXML spells it (selection, data, field).

type?: string

Which way the rule runs over the areas, as OOXML spells it (none, all, row, column).