A function cannot change the formatting of any cell including itself.

You can gain color formatting and borders by using Conditional
Formatting, but you are not copying formatting from another cell.

You would need to use a macro, or copy manually.

To copy only the formatting manually
Copy the source selection
to paste only the formatting
Edit, Paste Special, paste formats.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Vamshee" wrote in message ...
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