Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referencing a cell's data & format in Excel 2004 for Mac
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In Excel, conditional format (font red) referencing another cell? | Excel Worksheet Functions | |||
Changing Where Data Validation List Boxes Open in Mac Excel 2004 | Excel Discussion (Misc queries) | |||
How do I get the color format to follow the data when referencing. | Excel Worksheet Functions | |||
I can't format 01/19/2004 to read January 19, 2004, please help!! | Excel Discussion (Misc queries) | |||
Locking a cell's format, but not value | Excel Discussion (Misc queries) |