title: Script to Change Row Color when a cell changes text
body: <p>I have a Google spreadsheet where I keep a list of bugs  and whenever I fix a bug I change the status from "Not Started" to "Complete". I want to write a script for the Google Docs spreadsheet such that whenever I change the status to "Complete" the entire row gets highlighted in a certain color.</p>
  
  <p>I already know that Google spreadsheet already has "change color on text" but that function only changes the color of the cell and does not change the color of the entire row.</p>