Excel 2007 - copy colors from another workbook
 

Hi there - So simple in earlier versions. (Tools\Options\Color tab\Copy
colors from)

How to do so in 07? Copy cell styles from another workbook doesn't seem to
work, nor does the Excel options Advanced tab.


Thanks!

sam

Here is my own solution for restoring the original colors when copying certain highly formatted sheets or templates to a new 2007 spreadsheet.. it copies all data directly, so it only works if you need to copy an entire sheet and import / restore all the colors, not only apply colors to a different sheet with different data:

first, open both workbooks

copy the original format workbook by ctrl + g and selecting the appropriate range

paste it into the new work sheet, colors will be all changed

with the destination still highlighted, right click and go to "Paste special" and select "All using source theme", then repeat the paste special, only with "Values" this time, and it should be identical to the original sheet you copied