Reference to content AND formating of target cell

  • Thread starter Thread starter 0-0 Wai Wai ^-^
  • Start date Start date
0

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?
 
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
 
Back
Top