title: Trying to create a Conditional Formatting rule. Having some Issues
body: <p>I need the rule to display the dates in Column AA in red text IF the dates are BEFORE today AND if the status is NOT "Delivered".</p>
  
  <p>Here is what I have:</p>
  
  <pre><code>=IF(AND($AA2&lt;(TODAY()),X2&lt;&gt;"Delivered"),TRUE)
  </code></pre>