In the WS code module
In the test attachment WB, I put some formulas in to the copy area that point to col M to make sure that changes were picked up
Conditional Formatting compares the 'copied' to the 'copy' including cells with formulas
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
Dim r As Range, rSrc As Range, rDest As Range
Dim sDest As String
Set r = Target.Cells(1, 1)
If Len(r.Value) = 0 Then Exit Sub
If r.Column <> 7 Then Exit Sub
If r.Row Mod 11 <> 1 Then Exit Sub
Set rSrc = r.Offset(-11, -6).Resize(11, 5)
Set rDest = r.Offset(0, -6).Resize(11, 5)
sDest = rDest.Cells(1, 1).Address(False, False)
rSrc.Copy rDest
With rDest
.FormatConditions.Delete
.FormatConditions.Add Type:=xlExpression, Formula1:="=" & sDest & "<>OFFSET(" & sDest & ",-11,0)"
.FormatConditions(.FormatConditions.Count).SetFirstPriority
.FormatConditions(1).Interior.Color = vbRed
.FormatConditions(1).StopIfTrue = False
End With
End Sub