function that will highlight a cell red when it is marked 'incomplete' and white when it is anything else

readme.md

#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.

highlightIncompletes

function onEdit(event) {
  if(event.value.toLowerCase() === "incomplete") {
    event.range.setBackground("red");
  } else  {
    event.range.setBackground("white");
  } 
}