Sometimes when I copy and paste from one book to another, the destination color scheme looks very strange. How do I copy a color scheme from one book to another?
Open VBA and enter the following (change workbook titles)
workbooks("DestinationWorkbook.xlsx").Colors=workbooks("SourceWorkbook.xlsx").Colors