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.

Interpolation Type

An enumeration representing the interpolation options for calculating a value to be used in a Gradient Condition in a Conditional Format Rule .

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.