title: Excel; Conditional formatting Date/Time between two columns
body: <p>I have two columns, for example Column A and B with the below style of set up.</p>
  <p>What I am wanting to do is to highlight both columns in a colour based on certain parameters.</p>
  <p>For example: If Column B is due to occur AFTER Column A - no colour. If Column B is due to occur at the SAME TIME as Column A - Highlight both cells in yellow. If Column B is due to occur BEFORE Column A - Highlight in Red.</p>
  <p>Please see below examples of the kind of data I would be working with, and then below it an example of what it would look like should the conditional formatting colour it in correctly.</p>
  <p>Thank you.</p>
  <p><a href="https://i.stack.imgur.com/R7JbK.png" rel="nofollow noreferrer">Base Data</a>
  <a href="https://i.stack.imgur.com/waBDw.png" rel="nofollow noreferrer">Completed Formatting</a></p>