Reference to content AND formating of target cell

[0-0 Wai Wai ^-^]

Hi.
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 so that the exact formating (eg bold, font size, font color,
backgorund colr etc.) will be preserve as well?

--
Additional information:
- I'm using Office XP
- I'm using Windows XP

[Ninja Stevie]

conditional formatting.

[0-0 Wai Wai ^-^]

"Ninja Stevie" <stevie.holmes@gmail.com> ???
news:1126134516.995378.263860@o13g2000cwo.googlegroups.com ???...
> conditional formatting.
>

Sorry, but how is it possible to do what I want by conditional formatting?

[0-0 Wai Wai ^-^]

Note:
I have moved and update my question to "microsoft.public.excel.misc"

The updated question is:
==========================
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

--
Additional information:
- I'm using Office XP
- I'm using Windows XP
============================