Enum BandingTheme

  • BandingTheme is an enumeration used to define color schemes for banding in Google Sheets.

  • You can apply a banding theme to a sheet using the SpreadsheetApp.BandingTheme enum followed by the specific theme name, such as LIGHT_GREY or CYAN.

  • There are a variety of pre-defined color themes available like LIGHT_GREY, CYAN, GREEN, YELLOW, ORANGE, BLUE, TEAL, GREY, BROWN, LIGHT_GREEN, INDIGO, and PINK.

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.

Properties

PropertyTypeDescription
LIGHT_GREYEnumA light grey banding theme.
CYANEnumA cyan banding theme.
GREENEnumA green banding theme.
YELLOWEnumA yellow banding theme.
ORANGEEnumAn orange banding theme.
BLUEEnumA blue banding theme.
TEALEnumA teal banding theme.
GREYEnumA grey banding theme.
BROWNEnumA brown banding theme.
LIGHT_GREENEnumA light green banding theme.
INDIGOEnumAn indigo banding theme.
PINKEnumA pink banding theme.