Link format along with contents of another cell

  • Thread starter Thread starter Claudia
  • Start date Start date
C

Claudia

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