customer style across sheets
 

I want to have a cell style, which utilizes a custom number formatting,
propagate and be readily available across all sheets, in both '07 and XP.
How do I accomplish this?

Seems like the only way I've figured out is to copy/paste from a sheet that
has the style and/or custom formatting, into the sheet where I'd like to use.
This is not practical, as I have to then always find the sheet which has the
style, open, copy/paste, close.

I have also tried using the Personal macro xl file, which I've got opening
each time, as the place to have one cell formatted with this style, but the
file is being treated the same way as any other file, in that I have to go to
Personal.xls, copy that formatting, and bring into the destination book. Not
what I want.

any help?
--
Boris