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