[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2024-12-02 UTC."],[[["\u003cp\u003e\u003ccode\u003eInterpolationType\u003c/code\u003e is used to define how values are calculated for gradient conditions in conditional formatting rules.\u003c/p\u003e\n"],["\u003cp\u003eOptions include using specific numbers, percentages, percentiles, or inferred minimum/maximum values as interpolation points.\u003c/p\u003e\n"],["\u003cp\u003eAccess enum properties using the format: \u003ccode\u003eSpreadsheetApp.InterpolationType.PROPERTY\u003c/code\u003e, replacing \u003ccode\u003ePROPERTY\u003c/code\u003e with desired value like \u003ccode\u003eNUMBER\u003c/code\u003e or \u003ccode\u003ePERCENT\u003c/code\u003e.\u003c/p\u003e\n"]]],[],null,["InterpolationType\n\nAn enumeration representing the interpolation options for calculating a value to be used in a\n[GradientCondition](/apps-script/reference/spreadsheet/gradient-condition) in a [ConditionalFormatRule](/apps-script/reference/spreadsheet/conditional-format-rule).\n\nTo call an enum, you call its parent class, name, and property. For example, `\nSpreadsheetApp.InterpolationType.NUMBER`. \n\nProperties\n\n| Property | Type | Description |\n|--------------|--------|--------------------------------------------------------------------------------------|\n| `NUMBER` | `Enum` | Use the number as as specific interpolation point for a gradient condition. |\n| `PERCENT` | `Enum` | Use the number as a percentage interpolation point for a gradient condition. |\n| `PERCENTILE` | `Enum` | Use the number as a percentile interpolation point for a gradient condition. |\n| `MIN` | `Enum` | Infer the minimum number as a specific interpolation point for a gradient condition. |\n| `MAX` | `Enum` | Infer the maximum number as a specific interpolation point for a gradient condition. |"]]