How to automatically change cell background color when cell is adjusted using Google Sheets? -
i have populated google spreadsheet multiple editors , need track changes made it. easiest way thought have cells automatically change background color red when adjusted user.
i.e. if user changes text in cell b3 "peter" "parker", b3's background color automatically change red.
is should done in script editor? if so, imagine function onedit (e) applicable?
any guidance appreciated.
-adam
this code that:
function onedit(e) { e.range.setbackground('red') }
in case need reset white background every , then
function resetbg() { spreadsheetapp.getactive().getsheets() .map( function (s) { s.getdatarange().setbackground('white') }); }
Comments
Post a Comment