Loose formating of linked cells

[jocoman]

HELP. Gee I hope there is a solution for this out there!.
I have a cell with a bunch of text in it. Some words are bold and some
are underlined. I have this cell linked to another cell on a different
sheet.
Guess what. the linked cell does not show any of the original
formating. The formating is lost.

Any workaround for this .PLEASE...

 

[Gary''s Student]

Linking does not carry formatting forward. Use Copy/Paste.

 

[jocoman]

Linking does not carry formatting forward. Use Copy/Paste.

I don't want to copy and past. I'm linking hundreds of cells!!!!

 

[Gary''s Student]

I don't know of any easy solution to your problem.