title: Force conditional formatting apply
body: <p>I have a google spreadseet table with conditional background formatting rules on it. I also have a function that autosort sheet when user change a cell (it's a list of tasks with priorities). Unfortunately, the autosorting can somehow set a wrong background for cells which can be fixed manually by selecting a column and then clicking "background->reset parameters" button. I need to do the same with script automatically to keep correct backgrounding of cells. How do I force google-spreadsheet to re-render cells with its conditional formatting rules?
  Autosorting function:</p>
  
  <pre><code>function onEdit(event){
    var sheet = event.source.getActiveSheet();
    var editedCell = sheet.getActiveCell();
  
    var columnToSortBy = 1;
    var tableRange = "A2:Z1000";
  
    if(editedCell.getColumn() == columnToSortBy){   
      var range = sheet.getRange(tableRange);
      range.sort( { column : columnToSortBy, ascending: false } );
      // code below doesn't help to solve the problem:
      //var statusRange = sheet.getRange("B2:B1000");
      //statusRange.clear({formatOnly: true})
      //statusRange.clearFormat();
      //SpreadsheetApp.flush()
    }
  }
  </code></pre>