Enum InterpolationType
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. |
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2024-10-31 UTC.
[null,null,["Last updated 2024-10-31 UTC."],[[["`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`."]]],[]]
