Automatically update fill color on linked sheets

[howard]

I would like to know how to automatically change the fill color on a linked sheet when fill color is changed or a new cell in set using a fill color on the source sheet (sheet1)


Your assistance in this regard is most appreciated

 

[Fluff]

also covered in https://www.mrexcel.com/forum/excel-questions/1059904-copy-range-names-applicable-sheet.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).