Option Explicit Sub c() Dim r As Range For Each r In Worksheets("Sheet2").Range("A1:C1") r.Interior.ColorIndex = Worksheets("Sheet1").Cells(r.Row, r.Column).Interior.ColorIndex Next End Sub