title: Formatting based on Answer
body: <p>In a Sheet, I need to change the background color of a cell based on certain requirements. Logic:  </p>
  
  <blockquote>
    <p><strong>If L2 does not have a date,</strong> then  </p>
  </blockquote>
  
  <p>if date in D2 is before tomorrow, have no formatting in D2,<br>
   if date in D2 is tomorrow, have yellow background in D2,<br>
   if date in D2 is today, have red background in D2.  </p>
  
  <blockquote>
    <p><strong>If L2 has a date,</strong> then  </p>
  </blockquote>
  
  <p>have green background in D2.  </p>
  
  <p>This will be present through entire sheet.</p>