function onEdit() { var sheet = SpreadsheetApp.getActiveSheet(); var range = sheet.getDataRange(); var actCell = sheet.getActiveCell(); var actData = actCell.getValue(); var actRow = actCell.getRow(); if (actData != '' && actRow != 1) //Leaving out empty and header rows { range.getCell(actRow, 2).setBackground(actData); } }