I have two tabs. Tab "A" contains data that is pasted during a macro. Tab "B" uses INDEX and MATCH formulae to return values from "A" because the row and columns vary week to week.

Here's the challenge.... The data in the cells in tab "A" will be either 'no fill', or green, or red. I would like for the corresponding linked-cell in "B" to also have the color of it's twin on "A"...

I'm told that absent a rule for the colors (there is none), that VBA would be my only hope... Help me Obi-Wan.

Thank you for any direction!