title: Paste Highlighted Cells to Other Column
body: <p>I have a conditional format that highlights all duplicate values on column A and would like all highlighted values to be pasted on column B. The issue is, there are 160k rows for the column, and am unable to find what cells are highlighted due to the sheer number of rows. Is it possible to copy all highlighted cells in column A and paste those values onto column B? I attempted to sort by filter color, but the limit is 10,000 rows so if row 10,001 is highlighted, it will not be displayed. </p>
  
  <pre><code>A                B
  abc1           abc1
  abc2           abc1
  abc1              
  test3                
  abc3
  </code></pre>
  
  <p>I am using this highlight color, not sure what value it is in VBA. <a href="https://i.stack.imgur.com/yxlWg.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/yxlWg.png" alt="enter image description here"></a></p>