worksheet function - 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.

Answer

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