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