/* CODE FOR DEMONSTRATION PURPOSES */ function setFontAndBackgroundColorCell() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getSheets()[0]; var cell = sheet.getRange('B2'); cell.setFontColor('yellow'); cell.setBackground('red'); cell.setValue('TEST'); } /* CODE FOR DEMONSTRATION PURPOSES */
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