I need to write a script to see if a cells value is found in an array, and if it is change the background color of that cell.  Can't do this with Conditional Formatting as it needs to compare with 25 - 30 values.
Format a Cell with Script
google spreadsheets