title: Conditional Formatting Based on Prior Columns Data
body: <p>I read another post (<a href="https://stackoverflow.com/questions/25547723/conditional-formatting-based-on-relative-column">Conditional Formatting based on relative column</a>) but the answer did not work for me and I am unable to comment due to low reputation.</p>
  
  <p>I have a reporting spreadsheet where column J represents data as of last update and column K represents data from current update. <a href="https://i.stack.imgur.com/t7dl8.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/t7dl8.png" alt="Spreadsheet Example"></a> and I am trying to see the changes in any data points using conditional formatting.</p>
  
  <p>The problem arises when Excel starts to compare a date to a number (as seen in column L compared to column K). I want to be able to dictate to Excel that it should not evaluate one after the other (K-J;L-K) but that it should move in groupings (K-J;M-L;O-N) essentially skipping over the prior used column in the evaluation.</p>
  
  <p>Any and all ideas appreciated</p>