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:

Please Login or Register  to view this content.

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:

Please Login or Register  to view this content.

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)