FG
💻 Software

Excel: copy cell formatting in equation

Fresh6 days ago
Mar 15, 2026100347 views
Confidence Score0%
0%

Problem

If I make an equation: 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.

Error Output

' on cell A2
=A1

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Excel: copy cell formatting in equation

Low Risk

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

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment