Text format in referencing

  • Thread starter Thread starter Arthur
  • Start date Start date
A

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
 
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
 
Back
Top