0

Is it possible to automatically color cell backgrounds if their values has been changed (in my case, the only time a cell changes value is by manual user edit/input - no cell values are computed of functions of other cells)?

4
  • Yes, it's possible by using Google Apps Script. For further details please add a brief description of your search/research efforts as is suggested in How to Ask. May 20, 2020 at 13:50
  • @Rubén I looked into Conditional Formatting, but none of the presets yielded the desired function.
    – tsorn
    May 20, 2020 at 14:04
  • You could use the an edit trigger (simple or installable). The edit event object include value and oldValue properties but only when a single cell is edited, so if you are expecting data being added by copy/pasting multiple cells then you should make a copy of the values somewhere. May 25, 2020 at 20:19

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.