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
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"jackrobyn1" wrote in message
...
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