Referencing a cell's data & format in Excel 2004 for Mac

L

lissathierry

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLOOKUP Reference Help 4
Referencing a cell 6
Using data in cell for sheet referencing in formulas 3
referencing cells in different workbooks 2
Conditional Formatting 4
Referencing a cell even if its contents are moved moved/replaced 6
Referencing Sequential Sheets. 4
CountIf formula problem when referencing a column. 4

Top