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?