Thread: cell colour
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default cell colour

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