reference a cell AND its format in a new cell

[TiChNi]

Seems like there would be a simple way to reference a cell and any
formatting it has. For example, A1=5 and the 5 is underlined and in
red. The entry in A2 is =A1 and I want A2 to show not only the 5 but
I also want it to preserve and show the same formatting that was
applied to A1. Thanks in advance for the help.

 

[Dave Peterson]

Formulas don't do this kind of thing.

You could copy|Paste????

 

[dranon]

Seems like there would be a simple way to reference a cell and any
formatting it has. For example, A1=5 and the 5 is underlined and in
red. The entry in A2 is =A1 and I want A2 to show not only the 5 but
I also want it to preserve and show the same formatting that was
applied to A1. Thanks in advance for the help.

You could try conditional formatting. Test the cell for equivalence to
A1 and, if found, change the formatting to whatever is in A1.