Stay organized with collectionsSave and categorize content based on your preferences.
BandingTheme
An enumeration of banding themes. Each theme consists of several complementary colors that are
applied to different cells based on the banding settings.
To call an enum, you call its parent class, name, and property. For example,SpreadsheetApp.BandingTheme.LIGHT_GREY.
[[["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\u003eBandingTheme\u003c/code\u003e is an enumeration used to define color schemes for banding in Google Sheets.\u003c/p\u003e\n"],["\u003cp\u003eYou can apply a banding theme to a sheet using the \u003ccode\u003eSpreadsheetApp.BandingTheme\u003c/code\u003e enum followed by the specific theme name, such as \u003ccode\u003eLIGHT_GREY\u003c/code\u003e or \u003ccode\u003eCYAN\u003c/code\u003e.\u003c/p\u003e\n"],["\u003cp\u003eThere are a variety of pre-defined color themes available like \u003ccode\u003eLIGHT_GREY\u003c/code\u003e, \u003ccode\u003eCYAN\u003c/code\u003e, \u003ccode\u003eGREEN\u003c/code\u003e, \u003ccode\u003eYELLOW\u003c/code\u003e, \u003ccode\u003eORANGE\u003c/code\u003e, \u003ccode\u003eBLUE\u003c/code\u003e, \u003ccode\u003eTEAL\u003c/code\u003e, \u003ccode\u003eGREY\u003c/code\u003e, \u003ccode\u003eBROWN\u003c/code\u003e, \u003ccode\u003eLIGHT_GREEN\u003c/code\u003e, \u003ccode\u003eINDIGO\u003c/code\u003e, and \u003ccode\u003ePINK\u003c/code\u003e.\u003c/p\u003e\n"]]],["BandingTheme defines color schemes for spreadsheet cell banding. Themes, accessed via `SpreadsheetApp.BandingTheme.PROPERTY`, apply complementary colors based on banding settings. Available themes include `LIGHT_GREY`, `CYAN`, `GREEN`, `YELLOW`, `ORANGE`, `BLUE`, `TEAL`, `GREY`, `BROWN`, `LIGHT_GREEN`, `INDIGO`, and `PINK`. Each theme is an `Enum` type, and the selection will determine the color combinations applied to banded cells.\n"],null,["# Enum BandingTheme\n\nBandingTheme\n\nAn enumeration of banding themes. Each theme consists of several complementary colors that are\napplied to different cells based on the banding settings.\n\nTo call an enum, you call its parent class, name, and property. For example, `\nSpreadsheetApp.BandingTheme.LIGHT_GREY`. \n\n### Properties\n\n| Property | Type | Description |\n|---------------|--------|------------------------------|\n| `LIGHT_GREY` | `Enum` | A light grey banding theme. |\n| `CYAN` | `Enum` | A cyan banding theme. |\n| `GREEN` | `Enum` | A green banding theme. |\n| `YELLOW` | `Enum` | A yellow banding theme. |\n| `ORANGE` | `Enum` | An orange banding theme. |\n| `BLUE` | `Enum` | A blue banding theme. |\n| `TEAL` | `Enum` | A teal banding theme. |\n| `GREY` | `Enum` | A grey banding theme. |\n| `BROWN` | `Enum` | A brown banding theme. |\n| `LIGHT_GREEN` | `Enum` | A light green banding theme. |\n| `INDIGO` | `Enum` | An indigo banding theme. |\n| `PINK` | `Enum` | A pink banding theme. |"]]
