Reference cell formats + content

[0-0 Wai Wai ^-^]

Hi.
How can I tell one cell to follow content AND/OR formating of another cell?
Here's an example:

A1:
=I am the <b>best!</b> (<b>...</b> means bold letters)

A2:
=A1
Returns: =I am the best! (without bold)

What can I do to tell A2 to follow:
- content AND formating of another cell
- formating only of another cell

 

[Peo Sjoblom]

Not possible using formulas

 

[Guest]

you can copy and then paste special

 

[0-0 Wai Wai ^-^]

How about by Marco or creating a custom formula?

Not possible using formulas


--

Regards,

Peo Sjoblom

 

[0-0 Wai Wai ^-^]

Thanks for your idea.
But this could not maintain a dynamic link between 2 cells (ie when one cell
changes, another cell will not change)