If I make an equation:
' on cell A2
=A1
Is there a way to make A2 have the exact same formatting as A1 and not just the value?
i.e. I want a FORMULA that copies both the value and the format/including conditional formatting of the original/source cell.