Google Apps Script – set colors by row – part 024.

This tutorial will show you how to alternate the colors by row.
The first part will select by variables the active Spreadsheet, the sheet named Sheet1 and the range area.
The for loop will parse all rows by modulo and set a variable named range_input.
The color are changed by the setBackgrounds.

This is the output:

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.