title: Trigger an email when a cell is a certain colour?
body: <p>I have very VERY limited knowledge on this. So little I probably shouldn't even refer to it as "knowledge"</p>
  
  <p>This is what I'm trying to do:
  I have a column with dates referring to send dates. If the date has already passed, the cell turns red (#a33838). I want to send an email if a cell in that column turns red, so that I know it has not been sent, and needs doing.
  I also want the email to hold the information of the row that cell is in</p>
  
  <p>I have been looking through the forums and I think I need a mixture of these two different posts:</p>
  
  <p><a href="https://stackoverflow.com/questions/41561772/change-cell-value-based-on-cell-color-in-google-spreadsheet">Change cell value based on cell color in google spreadsheet</a></p>
  
  <p><a href="https://stackoverflow.com/questions/26547798/trigger-an-email-when-a-cell-has-certain-values">Trigger an email when a cell has certain values</a></p>
  
  <p>If anyone knows a way to do this, it would really be a lifesaver!
  Thanks so much.</p>