title: How can Excel do conditional formatting based on a comparison with the above cell?
body: <p>I have a table which is supposed to have a sequential id number at the beginning as in 1,2,3,4,5,6....</p>
  
  <p>HOWEVER, during the export of the data, there appears to have been a bug which pastes two rows on just one row thus breaking the sequence. I am trying to identify these rows by conditonal format and am currently using this formula which is not working:</p>
  
  <pre><code> ="IF($A2+1==$A3,TRUE,FALSE)"
   # Note the +1 is to account for the header row
  </code></pre>
  
  <p>I have tried moving the "$" around, but still no cigar.</p>
  
  <p>My other option is to compare the sequence to the row number as in:</p>
  
  <pre><code> ="IF($A2+1=ROWS($A1), TRUE, FALSE)
  </code></pre>
  
  <p>but that hasen't worked either.</p>
  
  <p>I'm guessing it has to do with </p>
  
  <p>I am trying to conditionally format the column so that I can identify where I need to insert a row and make a copy paste.</p>
  
  <p>Right now, I am trying to use conditional formatting but am failing in this regard. I don't know how to use VBA so as of now, I would prefer to use the menu before getting into VBA.</p>