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