Hi ExcelGuy160

Here is how to combine all those ANDs and makes it more readable. I only did the top for you. You can figure out the second one.

If Range("A4") = Range("A3") Then
    If Range("B4") = Range("B3") Then
        If Range("C4") = Range("C3") Then
            If Range("E4") = Range("E3") Then
                If Range("F4") = Range("F3") Then
                    If Range("G4") = Range("G3") Then
                        Range("D3") = Range("D3") & Range("D4")
                        Range("A4:G4").Font.ColorIndex = 50
                    End If
                End If
            End If
        End If
    End If
End If