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

Popular posts from this blog

Magento/PHP - Get phones on all members in a customer group -

php - .htaccess mod_rewrite for dynamic url which has domain names -

Website Login Issue developed in magento -