Skip to content

Instantly share code, notes, and snippets.

@mbierman
Created April 2, 2014 19:04
Show Gist options
  • Save mbierman/9940873 to your computer and use it in GitHub Desktop.
Save mbierman/9940873 to your computer and use it in GitHub Desktop.
Set color for entire row in Google Spreadsheet based on Column A
function upColor() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName('Sheet1'); // Change to your own
var rows = sheet.getRange('A1:A');
var numRows = rows.getNumRows();
var values = rows.getValues();
for (var i = 0; i <= numRows - 1; i++) {
for (var x in values[i]){
var n = i + 1;
if (values[i][0] == "----")
sheet.getRange(n + ':' + n).setBackgroundColor('#62847B');
else if (values[i][0] <= 60)
sheet.getRange(n + ':' + n).setBackgroundColor('#FCD920');
else if (values[i][0] > 60 && values[i][x] <= 80)
sheet.getRange(n + ':' + n).setBackgroundColor('#EC6C20');
else if (values[i][0] > 80 && values[i][x] <= 150)
sheet.getRange(n + ':' + n).setBackgroundColor('#3CB5B5');
else if (values[i][0] > 150)
sheet.getRange(n + ':' + n).setBackgroundColor('#E53B51').setFontColor('#FFFFFF');
else
sheet.getRange(n + ':' + n).setBackgroundColor('white');
}
}
};
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment