Let me explain my issue with an example.

Lets say I have a link to a website , for example http://www.microsoft.com/
in cell A1 which is formatted in a specific font and color and is also a
hyperlink. When I want to have the same information in cell A1 in other cells
say C3 and B5, I use =A1 in the cells C3 and B5.

But what happens is that only the information http://www.microsoft.com is
copied to cells C3 and B5 and not the format of the text or the hyperlink.

How can I have the format also to be copied to cells C3 and B5 when
referencing.

Thanks in advance.


Vamshee