How do you get the cell formatting (color) to transfer to a linked cell?

Example: I have added color (red) to a particular cell (A1) in Sheet1. I
have linked cell (B2) in Sheet 2 to the red colored cell (A1) in Sheet1 (i.e.
=+Sheet1!A1). The cell value (A1) on Sheet1 transfers to the cell (B2) in
Sheet2, however the color (red) does not transfer to cell (B2) in Sheet2. I
want the cell value and the color (red) to transfer from cell (A1) Sheet1 to
the cell (B2) in Sheet2. Is there a way to get the cell formatting/color to
transfer along with the cell values from one linked cell to another? Thanks
for any help. Scott

Hi!

The short answer is no!

A formula (which is what a "link" is) can only return a value, not
formatting.

=+Sheet1!A1

You don't need the "+" sign. It's superfluous.

You might be able to use conditional formatting to color the cell if there's
some logic that determines why the cells need to colored.

Biff

"Scott" wrote in message
...
How do you get the cell formatting (color) to transfer to a linked cell?

Example: I have added color (red) to a particular cell (A1) in Sheet1.
I
have linked cell (B2) in Sheet 2 to the red colored cell (A1) in Sheet1
(i.e.
=+Sheet1!A1). The cell value (A1) on Sheet1 transfers to the cell (B2) in
Sheet2, however the color (red) does not transfer to cell (B2) in Sheet2.
I
want the cell value and the color (red) to transfer from cell (A1) Sheet1
to
the cell (B2) in Sheet2. Is there a way to get the cell formatting/color
to
transfer along with the cell values from one linked cell to another?
Thanks
for any help. Scott

Biff: Thanks. I will try conditional formatting and see if I can get
acceptable results. Scott

"Biff" wrote:

Hi!

The short answer is no!

A formula (which is what a "link" is) can only return a value, not
formatting.

=+Sheet1!A1

You don't need the "+" sign. It's superfluous.

You might be able to use conditional formatting to color the cell if there's
some logic that determines why the cells need to colored.

Biff

"Scott" wrote in message
...
How do you get the cell formatting (color) to transfer to a linked cell?

Example: I have added color (red) to a particular cell (A1) in Sheet1.
I
have linked cell (B2) in Sheet 2 to the red colored cell (A1) in Sheet1
(i.e.
=+Sheet1!A1). The cell value (A1) on Sheet1 transfers to the cell (B2) in
Sheet2, however the color (red) does not transfer to cell (B2) in Sheet2.
I
want the cell value and the color (red) to transfer from cell (A1) Sheet1
to
the cell (B2) in Sheet2. Is there a way to get the cell formatting/color
to
transfer along with the cell values from one linked cell to another?
Thanks
for any help. Scott