title: Excel Conditional Formatting Probsss
body: <p>I am using conditional formatting in Excel to compare two sets of data (set 1 in column A and set 2 in column D). The conditonal formatting is in column F so if column A=D then column F will turn green and if A /= D then column F will turn red. 
  The problem is when I delete the first cells in A and D and shift all the cells below up, the whole conditional formatting gets erased. Is there a way to keep that conditonal formatting permanent? </p>
  
  <p>[Im having trouble uploading pics for some reason...if I could, I would include a pic so it's easier to understand what's goin on]</p>