Text format in referencing

[Arthur]

When you use cell referencing where the text of the
original cell has Bold, Underline, etc formating, only the
value of that cell transfers into the new cell. Is there a
way of keeping all formating from the original cell to the
new cell, accross worksheets and workbooks as well?

IE cell A1 has bolded/italics/underlined etc content
cell A10: =A1

the result is A10 has plain text equivilant of A1
desired result is A10 has same exact content as A1

-Arthur

 

[Peter]

Arthur

No =A10 is a formula referring to the contents, not the
format of A10.
You can use Format Painter manually or write a macro

Regards
Peter