Not possible to link cell formatting.

Nearest you can get is starguy's copy formats.

Note: if you change formatting in source book, you will have to again copy
formats manually.


Gord Dibben MS Excel MVP

On Thu, 17 Aug 2006 08:17:01 -0700, KimW <KimW@discussions.microsoft.com> wrote:

>I am linking data from one workbook to another - to pre-populate cells in
>planning templates. I have no problems linking the data. Hoever, I would also
>like to link the formatting (cell shading, font color, etc.)
>
>Is this possible and if so, how?