How can I copy the cell format along with the cell value?
For example cell A1 contains:
=indirect(B1) and B1 has the text value "C1" and cell C1 has "Rabbit" in red, Calligrapher 10 font.
Cell A1 evaluates to "Rabbit" but it does not copy the font nor the font color to A1.