Under Excel 2010 whenever I copy an existing sheet to a new workbook, excel formats the text as bright green and borders as red. This never happened under prior Excel versions. All my sheet have black borders, a dark fill in the headers and black text. I know how to fix it. Truthfully, my question is how to prevent this from happening. I would prefer Excel to retain the source format. I have a dozen macros and a dozen conditional formatting rules on the spreadsheet.