Look up Format Painter in Help. HTH Otto
"Tom Liu" <Tom wrote in message
...
In Excel 2003, color schemes can be copied between workbooks, by going
through Tools--Options. I can't seem to find this function in Excel 2007.
Does anyone know how to do this?