Formula that copies values AND formatting

A1 = “Hello World!” in bold.  In cell A2, there is a formaula =A1.  I want A2 to match the formatting of A1 but don’t know how to do that.  More complex example:  Hello is red and World is black.  I want A2 to match the formatting of A1.  Preferably using only formulas. 

I cannot figure out how to do this.  I cannot even figure out how to succinct describe the problem well enough to adequately search for a solution.  Formatting included in formulas?

I read an old post on another site that what I want is not possible using formulas but requires VBA.  But no code was provided.

Thanks for any suggestions.

[I’m using Excel 2013.]

By: Steve Rittenberg

Leave a Reply

Your email address will not be published. Required fields are marked *