How to Highlight Edited Cells
How to Highlight Edited Cells in Google Sheets Using Apps Script
In this video, learn how to highlight edited cells with a custom color in Google Sheets using Apps Script. We will not be using conditional formatting, but we'll write a function called 'onEdit' to detect changes in cells and modify their background color. Follow along to see how you can automatically highlight cells when their contents are edited.
00:00 Introduction to Highlighting Edited Cells
00:13 Setting Up the Apps Script
00:23 Writing the onEdit Function
00:25 Accessing Edited Cell Information
00:45 Changing Cell Background Color
01:01 Saving and Testing the Script