Please could someone help,

I have conditionally formatted a range of cells in a column based on another column to highlight duplicates.

I would now like to copy all of the highlighted values to another column in the same row - can this be done by VBA or using a formula to determine acknowledge the CF and copy/paste the cell value not the fomula?

Thanks in advance!!