I wish there were a built-in keyboard shortcut for the format painter in Excel. There is one in Word - just highlight some text, use Ctrl-Shift-C to copy the format, highlight the text whose format you want to change, and then use Ctrl-Shift-V to paste it. I tried it in Excel but it didn't work.

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com