Is there any way to carry the formatting of a cell to a linked cell,
particularly the font colour so that if the font colour is changed in
the parent cell the font colour will change in the linked cell?

Any help is appreciated.