Conditional formatting - If cell colour is, then change cell colour in another tab. (Google Sheets)

[Roksman]

Hi All,

I cannot work out how to change a cell colour based on another cell with the same value.

I.e. If I change A9 cell colour to red, can I then have the same value cell in tab "Midfielders" (A15) also change to red automatically?

Effectively, tab "2022 list" is my primary checklist and as I highlight the cells in this list, can the corresponding matching name across tabs 'DEFENDERS', 'MIDFIELDERS', 'RUCKS' and "FORWARDS' mimic these changes?

Any assistance will be much appreciated.

 

[Fluff]

Duplicate to: If cell colour is, then change cell colour in another tab (with matching value).

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.