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

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