title: Storing/loading conditional format info in VBA
body: <p>is there a way I can store and later restore conditional formatting information? Upon selecting a cell, I want to 
  1/ store the condformatting of the corresponding column/row in some arrays
  2/ delete the condformatting of the corresponding column/row 
  3/ change InteriorColor of column/row to something nice (so that I see a crosshair)
  4/ upon selecting another cell, I want to restore the condformatting of the original column/row and repeat the process from 1/ for the currently selected cell. </p>
  
  <p>I tried something like </p>
  
  <pre><code>Public condFmt1 As FormatCondition
  Set condFmt1 = Range("A1").FormatConditions.Item(1)
  ...
  Set Range("A2").FormatConditions.Item(1) = condFmt1
  </code></pre>
  
  <p>however the last line gives me a runTime error 438 - Object does support this property or method. Im probably assigning wrongly. </p>