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

Conditiona format based on format of another cell 1
setting cell values based on a 3rd cell 4
Need Help 4
concatenate contents of cells whose contents resemble cell referem 3
How to return a blank formula cell if the reference is blank? 2
Excel Formula for Single Cell Adress 2
Using icon sets with relative references 0
Can UDF return a customized hyperlink? 3

Top