title: Script to Change Row Color with a input from a Google Form
body: <p>Basic conditioning formatting issue, (or so I thought); our spreadsheet acts as a Daily log, therefore, besides the top row (frozen titles), everything gets manually moved to an archive on a daily basis. This renders the innate Conditional Formatting function inert as it not longer works after the data move.</p>
  
  <p>So I found an modified a script until it works exactly the way we need it to, with one minor issue, all input is gathered thru the use of a Google Form, and even though the script works when the value in question is manually entered it does not function when entered thru the form, I tried using a trigger but to no avail.</p>
  
  <p>When the form is filled and submitted, a Radio Button (if selected), enters ME? onto column E, if that value is entered then A2:E gets a change in the font color and cell background color, otherwise is business as usual. This is the script as it currently stands:</p>
  
  <pre><code>function OnEdit(e) {
  if (e) { 
      var ss = e.source.getActiveSheet();
      var r = e.source.getActiveRange(); 
      if (r.getRow() != 1 &amp;&amp; ss.getName() == "Form Responses 0") {
  
          ME = ss.getRange(r.getRow(), 5).getValue();
          rowRange = ss.getRange(r.getRow(),1,1,5);
  
          // This changes font and row color
          if (ME == 'ME?') {
              rowRange.setFontColor("#056afa");
              rowRange.setBackground("#fae7bf");
  
          // DEFAULT
          } else if (ME == ' ') { 
              rowRange.setFontColor("#000000");
              rowRange.setBackground("#ffffff");
          }   
      }
  }
  </code></pre>
  
  <p>Any Help would be greatly appreciated...</p>