I am using two instances of Excel on two separate screens. In one screen I
have a workbook with custom color scheme and in the other a workbook with a
default color scheme.

Whenvever I copy data (either using paste or paste special) from a worksheet
in one book to a worksheet in the other, the color scheme is copied across as
well, thereby putting out the formatting of the colored cells.

Has anyone come across this or any thoughts as to a solution?