Enum InterpolationType
Page Summary
InterpolationType is an enumeration used for calculating values in
GradientConditionwithinConditionalFormatRule.To use an enum, call its parent class, name, and property, e.g.,
SpreadsheetApp.InterpolationType.NUMBER.Properties include
NUMBER,PERCENT,PERCENTILE,MIN, andMAX, 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 aGradient in aConditional.
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. |
Except as otherwise noted, the content of this page is licensed under theCreative Commons Attribution 4.0 License, and code samples are licensed under theApache 2.0 License. For details, see theGoogle Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2025-12-11 UTC.