Hi,

I am trying to copy over cells' conditionally formatted colors.

e.g.

Range(Cells(11, iColumn), Cells(Last_Row, iColumn)).Copy

Sheets(iComparisonSheet).Cells(5, iPortfolioNumber).PasteSpecial Paste:=xlPasteValues
But instead of just the values I need to copy the colors. Unfortunately they are all conditionally formatted so I can't use a paste special function.

any ideas?

Thanks in advance