title: Copy automatically only the color from one cell to another- EXCEL VBA
body: <p>I have cell <code>017</code>, the value and color of this cell is changing constantly due to a formula and conditional formatting.</p>
  
  <p>Cell <code>O16</code> changes constantly due to a formula too but the formula and their values are different from cell <code>017</code>.</p>
  
  <p>What I want is that cell <code>O16</code> contains the same color of cell <code>O17</code> automatically once the value of cell <code>017</code> has changed.</p>
  
  <p>There should be a solution in VBA. I hope your help.</p>
  
  <p>EDIT:</p>
  
  <p>User <a href="https://stackoverflow.com/users/3067523/simoco">simoco</a> has came up with a solution for Excel 2010 and later:</p>
  
  <pre><code>Private Sub Worksheet_Calculate()
      Range("O16").Interior.Color = Range("O17").DisplayFormat.Interior.Color
  End Sub
  </code></pre>
  
  <p>Unfortunately I use Excel 2007, Is there and equivalent to that code in 2007?.</p>