title: Copy Colors but not conditional formatting
body: <p>Please help me to understand how to Copy Colors from a specific cell but not conditional formatting. </p>
  
  <p>For example</p>
  
  <p>My Range A1 and A2 are merged cell with red color and with some value on it and I have to copy only that red color to Range B1 and B2 which have some different values. Is there any provision to satisfy it?</p>
  
  <p>I tried</p>
  
  <pre><code>Range("A1:A2").Copy
  
  Range("B1:B2").PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
  SkipBlanks:=False, Transpose:=False
  </code></pre>
  
  <p>but this will copy paste and merge the cell B1 and B2</p>