Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Link the format of one cell to another's
Is there any way to set one cell to always assume the format of another?
For instance: I've got a "Comments" column in a worksheet, and have linked cells in another sheet to that column, with a simple "=A1" formula. But in this case, only the original values appear, not hte format. Since I have different formats in each line of the origin worksheet, and I change them once in a while, it's very time consuming to copy the formats manually all the time. I would like the linked cells in the second worksheet to assume not only the value, but also the format of the original cell. Does anyone know if that is possible, and how? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Link the format of one cell to another's
Formulas bring back values--not formats.
If you're lucky, maybe you could mimic the formatting with format|conditional formatting. Or if you're not so lucky, you could use some macro that does the copy|paste special|formats for you. Fabiano wrote: Is there any way to set one cell to always assume the format of another? For instance: I've got a "Comments" column in a worksheet, and have linked cells in another sheet to that column, with a simple "=A1" formula. But in this case, only the original values appear, not hte format. Since I have different formats in each line of the origin worksheet, and I change them once in a while, it's very time consuming to copy the formats manually all the time. I would like the linked cells in the second worksheet to assume not only the value, but also the format of the original cell. Does anyone know if that is possible, and how? Thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cond. Format & Absolute Cell Reference Question | Excel Discussion (Misc queries) | |||
Why does my format keep changing in the cell? | Excel Discussion (Misc queries) | |||
how do I format a cell reference to move as source changes | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions | |||
copy combobox - cell link to change automatically | Excel Worksheet Functions |