Cell Formats in formulas

[Guest]

I have a worksheet set up with formulas to automatically copy values from
another cell as it is changed. Is there a way to include the format of the
reference cell (font, color) when referencing it in a formula. Example: when
I change to a different symbol font in the referenced cell, the referencing
cells only change the value, not the font, so I don't end up with the correct
symbols in the referencing cell.

 

[Guest]

No, it's not possible to do that using formulas, only format formulas can do
are number formats and only using the text function

Regards,

Peo Sjoblom