reference a cell AND its format in a new cell

T

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.
 
D

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.
Click to expand...

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