Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Change Google Spreadsheet tab/sheet color using script?

I'd like to use Google Scripts from within a Google Spreadsheet to change the tab color for the sheet (when you right-click a tab at the bottom, there's an option to Change Color, and there's a thin colored line under the name of the sheet/tab).

Can't find anything in the Google Spreadsheet Scripts documentation.

Any ideas?

Thanks!

like image 263
user2048172 Avatar asked Dec 09 '22 06:12

user2048172


1 Answers

FYI, Google have listened to the issue mentioned previously by Cyrus Loree and Bryan P and have now added the ability to colour the sheet tab using apps script.

See here: https://developers.google.com/apps-script/reference/spreadsheet/sheet#settabcolorcolor

Hope this helps someone!

like image 157
JonnyHarper Avatar answered Jan 09 '23 07:01

JonnyHarper