title: Conditional Formatting Excel Based On Date In Another Cell
body: <p>I looked through everything re conditional formatting, but nothing touched on my issue.</p>
  
  <p>I am trying to highlight cells in a column based on the date in another cell, as well as the text in the cell in question. I have been able to do both parts separately as basic conditional formatting, but not sure how to have it all work as one using a formula.</p>
  
  <p><code>A1</code> has the text and <code>D1</code> has the date. If the date is today and the text is either 2 or 3, I want the cell to be coloured using conditional formatting. </p>
  
  <p>Here is the formula I tried for conditional formatting, but with no result:-</p>
  
  <pre><code>=IF(AND($D1=TODAY(), OR(A1="3", A1="2")))
  </code></pre>
  
  <p>Basically, if the date in <code>D1</code> is today and <code>A1</code> is either a 2 or 3, then apply the conditional formatting. Seems simple, but I can only get it working as separate parts</p>
  
  <p>Thanks in advance</p>