How to copy cell formatting accross sheets.

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.

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:

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Range("A:A")) Is Nothing Then Target.Copy Sheets("Sheet2").Range(Target.Address)
End Sub

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

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.

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.