For example, cell A1 contains the text "Hello World" which is in bold.

In cell A2, I use the formula =A1. Therefore cell A2 now also contains "Hello World", but it is not in bold. How can I modify the formula to also copy the formatting (in this case, bold) of A1?

A more complex example is strikethrough properties, i.e. A1 contains "Orange/Red". How do I show the same content in cell A2 dynamically, so that any changes made in A1 will update A2 as well?

  • 1
    Has to be an option, I don't know anyway to solve this just with formulars, so without VBA or some other Magic, this won't work. There might be some way to use conditional formatting for this, but this will have quite some restirctions to it. – Jook Oct 17 '12 at 11:21

Using only formulas and no custom add-ons nor VBA: you can't. At least not with Excel up to 2007 (and quite probably all later versions as well)

First of all, there is no built-in formula that catches any form of formating.

Second, formulas only display their values. They don't influence formatting unless you use Conditional Formatting. But even if you do, there is no easy option to "copy formatting from the other cell". Besides, conditional formatting is limited in what it can format compared with "manual mouse clicking".

  • so is there any alternative? – Alvin Lim Oct 19 '12 at 9:03
  • 1
    Yes. As I've written: VBA or custom add-ons. – Adam Ryczkowski Oct 19 '12 at 13:39
  • 1
    @pnuts Yes. A good remark. I didn't think about it! – Adam Ryczkowski Apr 4 '13 at 8:55

Copy the cell then hit Alt-E-S-A-Enter Alt-E-S this opens up the paste special then A copies all properties

  • The OP is asking clearly how to do it with a formula not using the keyboard. – Ignacio Soler Garcia Feb 26 '20 at 15:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.