Skip to content

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

License

Notifications You must be signed in to change notification settings

esario/google-sheets-recolour-cells

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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.

About

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

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published