Copy format of cell from other worksheet

  • Thread starter Thread starter sirjibby
  • Start date Start date
S

sirjibby

When you tell a cell to display the contents of a cell from another worksheet
(eg. if in a cell from Sheet2 I put the formula ='Sheet1'!A1), how do you
also get it to use the formatting of that cell?

Thanks in advance for looking!
 
Formulas don't return this kind of formatting. They return values.

You could copy|paste or have a macro do it.
 
Ok thanks for letting me know. Could you possibly explain quickly how I would
get a macro to do that?
 
As quickly as you can record yourself doing the copy then Paste
Special>Paste links and Paste Special>Formats.


Gord Dibben MS Excel MVP
 
On top of what Gord suggested, you could have an event macro that runs that does
the copy|Paste.

But you'd have to share how the "sending" cell changed--is it because the user
typed something, or is it because the formula got reevaluated?

And if you're sharing this, share the details of what cells are sending cells
and what cells are the corresponding receiving cells.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code to format cells on several worksheets 2
Excel VBA 1
keeping format of a referenced cell 4
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Highlighting duplicates 0
protect cell format 1
Fill formula down for cells 74 rows apart 3
Formula to reference another worksheet 4

Back
Top