Cell copy

[ahhhmed]

In A1 I have a formatted text ( underlined, coloured ... ), in B1, I have this formula (=A1), but the result is just the text without formatting. How can I get the text with all the formatting in B1?

 

[Deepak]

Use Format Painter to copy format from a range.