Cell Formats in formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

inserting a hyperlink into a conditionally formatted cell, Excel 2 2
Reference Formula Help 1
Fixed/Locked cell referencing 6
Referencing a cell's data & format in Excel 2004 for Mac 1
Excel VBA 1
keeping format of a referenced cell 4
Formula error - cell reference 2
modify all formula references in multiple cells 3

Back
Top