View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default Referencing a cell's data & format in Excel 2004 for Mac

Not it's not possible


--


Regards,


Peo Sjoblom



"lissathierry" wrote in message
...
I am referencing a cell from one worksheet to another. The formula I am
using
is
=Sheet2!A2
The problem is, that it is referencing the data in the cell but it isn't
referencing the format of the cell. Is it possible to reference both the
data
& the format? I don't want to do this one time, I want Sheet1 to
automatically update each time the data or format on Sheet2 changes.

Thanks