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?

Open the two workbooks in the same instance of excel.

You can continue to use multiple monitors with a single instance.

You may want to review Chip Pearson's notes:
http://cpearson.com/excel/MultipleMonitors.aspx

IanC wrote:

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?

--

Dave Peterson