Copy color cells from other sheet similar to Lookup

I have two sheets, one is "Summary" sheet and the other is "Sheet1".

Both sheets has the same template.

The "Summary" has color bordered cells and the "Sheet1" has no color.

Whenever new color had been added to "Summary" sheet, I would like color from "Summary" sheet to be copied to "Sheet1" in same locations like if red been added to D12 cell in "Summary" sheet, D12 in "Sheet1" will automatically filled in red from "Summary" sheet.
Similar to Lookup.

Hope this has enough explanation and cannot find this similar problem in search. Thank you

Project_Reports_Cut.xls

I know that when you make a CHANGE to a cell on the SUMMARY sheet, it would be simple to copy the formatting of that cell over to sheet1, with something like this:

Private Sub Worksheet_Change(ByVal Target As Range)

    Target.Copy
    Sheets("Sheet1").Range(Target.Address).PasteSpecial xlPasteFormats
    Application.CutCopyMode = False
    
End Sub

But if the only change you make to a cell is formatting, Excel doesn't deem that important enough to trigger the _Change macro. Ugh.

Maybe something like THIS in the Sheet1 Module:

Private Sub Worksheet_Activate()
On Error GoTo ErrorFix
Application.EnableEvents = False
Application.ScreenUpdating = False
    
    Sheets("Summary").Cells.Copy
    Range("A1").PasteSpecial xlPasteFormats
    Application.CutCopyMode = False
    Range("A1").Select

ErrorFix:
Application.EnableEvents = True
Application.ScreenUpdating = True
End Sub

This effectively just copies all the formatting from the SUMMARY tab to Sheet1 each time you activate Sheet1.

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].

(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)