title: google script conditional formatting
body: <p>I have put together a google spreadsheet that highlights the first four cells in a row if the value in cell 6 is within 3 days of the current date, but I cannot figure out how to add an if/and statement to exclude all entries that have "East" in row E. </p>
  
  <p>This is the code that I have had success with, minus the exclusion of East not highlighting.</p>
  
  <pre><code>onEdit(e) {
  if (e) { 
  var ss = e.source.getActiveSheet();
  var r = e.source.getActiveRange(); 
  if (r.getRow() != 2 &amp;&amp; ss.getName() == "Sheet1") {
  Days_Remaining = ss.getRange(r.getRow(),6).getValue();
  rowRange = ss.getRange(r.getRow(),1,1,4);
  if (Days_Remaining &lt; 3.8) {
  rowRange.setBackgroundColor("#FF0000");
  } else if (Days_Remaining == 'N/A') {
  rowRange.setBackgroundColor("#ffffff");
  } else if (Days_Remaining &gt; 3.9) { 
  rowRange.setBackgroundColor("#ffffff");
  </code></pre>
  
  <p><a href="https://docs.google.com/spreadsheet/ccc?key=0AqtCuK7ex8ZNdGxKLUZpQnZ3UzRCV3VoclVDbFVqQnc#gid=0" rel="nofollow">https://docs.google.com/spreadsheet/ccc?key=0AqtCuK7ex8ZNdGxKLUZpQnZ3UzRCV3VoclVDbFVqQnc#gid=0</a></p>