Enum InterpolationType

AI-generated Key Takeaways

InterpolationType is an enumeration used for calculating values in GradientCondition within ConditionalFormatRule.
To use an enum, call its parent class, name, and property, e.g., SpreadsheetApp.InterpolationType.NUMBER.
Properties include NUMBER, PERCENT, PERCENTILE, MIN, and MAX, each representing a different interpolation point type for a gradient condition.

An enumeration representing the interpolation options for calculating a value to be used in a GradientCondition in a ConditionalFormatRule.

To call an enum, you call its parent class, name, and property. For example, SpreadsheetApp.InterpolationType.NUMBER.

Property	Type	Description
`NUMBER`	`Enum`	Use the number as as specific interpolation point for a gradient condition.
`PERCENT`	`Enum`	Use the number as a percentage interpolation point for a gradient condition.
`PERCENTILE`	`Enum`	Use the number as a percentile interpolation point for a gradient condition.
`MIN`	`Enum`	Infer the minimum number as a specific interpolation point for a gradient condition.
`MAX`	`Enum`	Infer the maximum number as a specific interpolation point for a gradient condition.