I have 2 sheets (in the same workbook) which have linked cells e.g.
In sheet 1 cell A1 is linked to cell B3 in sheet 2 using =sheet2!B3
This works fine in terms of the value of cell B3 but I also want the formatting to be the same i.e. fill colour & font details.
If I format B3 or change the format of B3, A1 will not change.
I've done it through recording a macro but I have lots of cells I want to do this to and therefore want any changes made to the active cell replicated in the linked cell.

Is there a way of doing this?

Thanks

Trevor: