Highlight Range

The Highlight Range action changes the background color of every cell in an A1 range.

Inputs

Input	Type	Required	Description
Third-party account	Google account	Yes	Account with write access.
Spreadsheet ID or URL	String	Yes	Spreadsheet to format.
Range	String	Yes	A1 range, such as `Sheet1!A1:B2`.
Color	Hex color	No	Six-digit `#RRGGBB` color. Defaults to `#FFD230`.

When the range does not include a sheet name, the action formats the first sheet in the spreadsheet.

This action changes only the cells’ background color and returns no output. It does not alter values, fonts, borders, or number formats.

The color is rejected

Use a hash followed by exactly six hexadecimal digits, such as #98FB98. Three-digit shorthand and alpha-channel colors are not accepted.