title: Detect when anything in a column is changed, google sheets
body: <p>Basically I want any edit within an entire column in google sheets to trigger an email. I've spent a long time looking but have been unable to find anything that addresses this issues. I want to automatically send a form anytime a value in an entire column is changed, using an OnEdit trigger. I have it working for when a specific cell changes, but cannot seem to get it for any value in the column. Currently I have this:</p>
  
  <pre><code>function autoEmailTest(e) {
   var ss = SpreadsheetApp.getActive();
   var sheet = ss.getSheetByName("Project Status");
  
  var valueToCheck = sheet.getRange("B2").getValue(); // "B2"
  var rangeEdit = e.range.getA1Notation();
  
  if (rangeEdit == "B2")    // stops changes from every cell triggering emails
     MailApp.sendEmail("xyz@email.com", "ACTION REQUIRED", "link here");  
  </code></pre>
  
  <p>} </p>
  
  <p>I've tried using     </p>
  
  <pre><code>'Project Status'!B:B 
  </code></pre>
  
  <p>as in the <a href="https://developers.google.com/sheets/api/guides/concepts#a1_notation" rel="nofollow noreferrer">documentation</a>, but since it seems to want a direct reference to a cell I'm not sure how to go about this. 
  Additionally, but not required, if anyone knows how to set the trigger to either include or exclusively happen when the cell colour is changed that would be helpful.</p>
  
  <p>Thank you in advance for any help.</p>