#Highlight Incompletes
Use the onEdit handler from google scripts to highlight a cell when it is marked 'incomplete'. If it is set to anything else then it reverts back to the original white.
Created
October 5, 2015 09:18
-
-
Save rheajt/3cb458abd0064a378ce6 to your computer and use it in GitHub Desktop.
function that will highlight a cell red when it is marked 'incomplete' and white when it is anything else
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| function onEdit(event) { | |
| if(event.value.toLowerCase() === "incomplete") { | |
| event.range.setBackground("red"); | |
| } else { | |
| event.range.setBackground("white"); | |
| } | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment