Change the color palette in a workbook Excel 2010

[Jono]

Hey,

I have recently upgraded from Excel 2003 to 2010.

I want to copy a color palette from one work book to another which I used to be able todo by selecting tools options.

However I can't firgure out how to do this in 2010.

Can someone please help?

 

[Andrew Poulsom]

Welcome to MrExcel.

I think you will find it under Excel Options on the File tab.

 

[nokycard]

Welcome to MrExcel.

I think you will find it under Excel Options on the File tab.

Yes, I found the command to open 2010 files using the colors that most closely match the color palette in my 2003 file. But how can I continue to use those colors for new files, since the new color "theme" does not match the colors in the 2003 palette?

 

[Andrew Poulsom]

File|Options|Save|Colors Button then select from the dropdown 'Copy colors from'.