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); } }
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter