Linking Cells from another Workbook

[simont485]

Hi all

I have linked one workbook to another but I need it to link the formatting as well, ideally the cell fill colours.

Is this possible?

Many thanks in advance!!

[jason.b75]

If it's conditional formatting then just apply the same rules.

If it's manual formatting, then it's not going to be so easy, you would need to copy and paste from the source file, which will not update to reflect changes in the source.

[simont485]

It is manual formatting sadly.....and as you say copy and paste wont update!