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