function myFunction() { id="1R5bR8DqSmghP8hK9pXyAJK_nrsWeFKYG91KnhC8S6sk"; var ex1 = SpreadsheetApp.openById(id); var sheet = ex1.getSheetByName("data"); sheet.getRange(1,1).setBackground('red'); sheet.getRange(2,2).setBackground('green'); }