Transfer Cell Formatting for linked cells

[Guest]

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]

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

 

[Guest]

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