Share via

How do I pull data and formatting from one cell to another using a formula in Excel?

Anonymous
2023-11-29T12:33:31+00:00

I am using = to pull through the text entered on one sheet in an Excel document to another sheet in the document. I've used this many times and it's always done what I needed it to but I am using it on a new document now and have noticed that it doesn't pull any formatting through. I only want basic formatting like italics to pull through but it's kind of crucial to the data in the document that non-italicised and italicised text shows. I have searched and searched but can't find any answer as to how I can use a formula to pull through the formatting of the text as well as the text. Does anyone have an idea on this? I basically want to be able to input all my information on one sheet but have certain cells pull through to a 'master' sheet in the same document, but I want the italics to show on the master.

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.6K Reputation points MVP Volunteer Moderator
    2023-11-29T13:05:02+00:00

    A formula cannot duplicate the formatting of cells it refers to. In particular, if a cell has mixed formatting (for example one word in bold, another in red), it is impossible to have a formula recreate that.

    On the other hand, if you apply conditional formatting to a cell, you can apply the same (or similar) conditional formatting rules to another cell containing a formula that refers to the first cell.

    6 people found this answer helpful.
    0 comments