Highlight Rows Based on Column in Google Sheets

highlightrows.gs

function onEdit(e){
  // Set a comment on the edited cell to indicate when it was changed.
  var sheet = SpreadsheetApp.getActiveSheet();
  statusColumn = 4;
  if (sheet.getActiveCell().getColumn() == statusColumn) {
    
    cell = sheet.getActiveCell();
    column = cell.getColumn();
    var row = sheet.getActiveRange().getRow();
    var cellValue = cell.getValue();
    var colLimit = 50
  
    switch (cellValue)  {
      case "Open":
        color = "#fff2cc";
        break;
      case "Closed":
        color = "#d9ead3";
        break;
      case "In Progress":
        color = "#fce5cd";
        break;
      case "Blocked":
        color = "#cfe2f3";
        break;
      default:
        break;
    }
    sheet.getRange(row, 1, 1, colLimit).setBackgroundColor(color);
  }
}