View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Is it possible to link cell formatting in Excel from file to file

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 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?