Enum InterpolationType

AI-generated Key Takeaways

• InterpolationType is used to define how values are calculated for gradient conditions in conditional formatting rules.

• Options include using specific numbers, percentages, percentiles, or inferred minimum/maximum values as interpolation points.

• Access enum properties using the format: SpreadsheetApp.InterpolationType.PROPERTY, replacing PROPERTY with desired value like NUMBER or PERCENT.

InterpolationType

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.

Properties

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.