/google-sheets-recolour-cells

Have Google Sheets automatically recolour cell background colours based on last update time to highlight recent changes.

Primary LanguageJavaScriptApache License 2.0Apache-2.0

Spreadsheet scripts

This project includes some examples of how to use Google Sheets to view recent changes by recoloring cells of the sheet

background_colors.js

This script assumes you are not using Notes (comments) in any of your cells
in your spreadsheet.  DO NOTE USE THIS SCRIPT if you rely on your own Notes.

To use this script, click on Tools -> Script Editor in your Sheet and paste
in the contents of this file.

Reopen your sheet, and make an edit. A couple seconds after editing, you
should notice the background color of the cell you edited turn green.

Reopen it again, and notice all cells will change color based on when they
were last edited.