reference a cell AND its format in a new cell

  • Thread starter Thread starter TiChNi
  • Start date Start date
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.
 
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.
 
Back
Top