Link format along with contents of another cell

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.
 
S

Sheeloo

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - Wich Function should I use? 1
Excel does not accept text format! 0
Referencing the values of multiple cells in conditinal formatting. 0
Conditiona format based on format of another cell 1
Conditional Formatting Formula 3
setting cell values based on a 3rd cell 4
Need Help 4
Can UDF return a customized hyperlink? 3

Top