Q:

Excel: copy cell formatting in equation

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.

A:

There doesn't exist any standard Excel function that does what you are asking. You need a user defined function to be built via VBA

