How to copy cell formatting accross sheets.

**alexneedshelp** · 05-14-2009, 04:25 PM

If I wanted to copy a cells formatting and content (Text) to another cell on a separate sheet, what code would I have to embed? I am a fresh neuling, so give it to me straight.

I have attached an example to this post.
I want to transfer the red and bold attributes of the words within the ( ) in sheet 1 to the cells in sheet 2 that I have linked to the cells in sheet 1 with =.

Thank you.

**mdbct** · 05-14-2009, 09:34 PM

Formula results cannot be formatted in the manner you desire.

**alexneedshelp** · 05-15-2009, 02:09 PM

That seems somewhat limited..

**StephenR** · 05-15-2009, 02:13 PM

You could copy and paste:

Please Login or Register  to view this content.

**JBeaucaire** · 05-15-2009, 02:39 PM

As already indicated, you cannot reflect varying formatting when pulling a value into a cell with a FORMULA. It only pulls in the value and any formatting in that cell applies. This is actually a very good thing. But not in your situation.

So, as I indicated in your other post on this topic, the only way to do this is with a real-time worksheet macro that mirrors the cells in question. Like so:

Please Login or Register  to view this content.

I set that example to duplicate the entire column A as you make changes, but you could define a smaller exact range, too.

**alexneedshelp** · 05-15-2009, 03:33 PM

So, if I utilize the code you have provided, it would simply copy the actions carried out on sheet #1, to sheet #2?

I must admit, I am quite confused.

Let me make this easier on all of you, helpful as you have been.

Will I be able to achieve what I am attempting? If not, it will not be a problem.

Also, could you recommend a online guide to VBA coding? The ones I have found do not seem to be that helpful.

**JBeaucaire** · 05-15-2009, 04:29 PM

I've shown you one way...and there are MANY...to type an entry on one cell and have it appear (formatting and all) in the same cell on a different sheet.

I'm not sure what new question you've asked.

**alexneedshelp** · 05-22-2009, 01:40 PM

...

So IT IS POSSIBLE to copy formatting within a cell that contains a FORMULA, in SEVERAL WAYS?
Somewhat contradictory, but alright. I got it.

I appreciate all of your help.

**JBeaucaire** · 05-22-2009, 01:57 PM

Heck, with VBA you could copy nothing BUT formatting...literally ignore the data and just cause your formatting choices in spot to be duplicated in another.

It can happen with on-demand macros, worksheet_activate macros, ws_change macros, ws_open...there are so many directions you can come from on this.

**mdbct** · 05-22-2009, 10:09 PM

So IT IS POSSIBLE to copy formatting within a cell that contains a FORMULA, in SEVERAL WAYS?

No - A cell containing a formula can have one and only one formatting. You cannot have part of the results one color and part another color (or bold or italic).