| Home |
| Search |
| Today's Posts |
|
|
|
#1
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) | |||
Hybrid Mode
