Copy and Paste only colors from Table 1 to Table 2 considering corresponding cells.

[learningstatistics]

Hello,

I have two tables. Left table and right table. What I want is to copy only the color of a certain cell from the right table to its corresponding cell in the left table.
So, cell (C,2018) is red in the right table so (C,2018) should be red in the left too.
Cell (A, 2021) is pink in the right table so (A,2021) should be pink in the left too.
Cell(A,2018) is white in the right table so (A,2018) should be white in the left too.
Please ignore the yellow part of the table.

Thank you!!!

 

[onlyadrafter]

Hello,

Does this work as expected?

Sub COLOUR_LEFT_TABLE()
    Columns("B:F").Interior.ColorIndex = xlNone
    For MY_ROWS = 2 To Range("A" & Rows.Count).End(xlUp).Row
        For MY_COLS = 16 To 20
            If Not (Cells(MY_ROWS, MY_COLS).Interior.ColorIndex) = xlNone Then
                MY_COLOUR = Cells(MY_ROWS, MY_COLS).Interior.ColorIndex
                Cells(MY_ROWS, MY_COLS - 14).Interior.ColorIndex = MY_COLOUR
            End If
        Next MY_COLS
    Next MY_ROWS
End Sub