Waffle Bytes

I have a fairly large spreadsheet we use to track requests for record transfers.  I've discovered recently that some of our larger schools are starting to use it to create internal requests.  This is fine, except when I am skimming through to make sure nothing is being overlooked I end up spending time on these internal requests, when I can bypass them. Hence, a short little script that will compare 2 data points in a row, then shade the row a particular color if the comparison is true. What the Script Does: It compares the values from two different columns to see if the first one is part of the second one - in this specific case it is checking the sending district against the receiving district.  If it is, then the row containing this record is shaded. The Script Here is the script I created to accomplish this - function setRowColor() {     var sheet = SpreadsheetApp.getActiveSheet();     var range = sheet.getDataRange();   ...