Link format along with contents of another cell
 

Say the formula in cell C1 is simply =A1. Is it possible to also link the
format of cell A1 to cell C1 so that if A1 is filled red, C1 will also be
filled red?

The shading in A1 is not based on cell contents so I can't figure out if it
can be done with conditional formatting.

Link format along with contents of another cell
 

You can NOT link formats through a formula provided by Excel...

To achieve this you will have to develop an User Defined Function and use that

------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"Claudia" wrote:

Say the formula in cell C1 is simply =A1. Is it possible to also link the
format of cell A1 to cell C1 so that if A1 is filled red, C1 will also be
filled red?

The shading in A1 is not based on cell contents so I can't figure out if it
can be done with conditional formatting.