cell colour

[Guest]

In a workbook i use i have a cell that has the following formula so it stays
the same value as another cell e.g.

=sheet2!$B$1

No problem. But what formula can i use so that the cell has the same value
and colour?, if i change the colour of the cell B2 i want the colour to
automatically change in the other cell.
Thanks

 

[Bernard Liengme]

A formula can only change the VALUE that is displayed; it cannot change the
format. You would need some VBA code to do that.
best wishes

 

[Dave Peterson]

Formulas can't return this kind of formatting. Formulas return values.

 

[Guest]

You cannot link color or other formatting, only values

 

[Bob I]

Use conditional formatting to set the cell color, and use the same
expression in both cells.