Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo Fin
If Target.Count > 1 Then Exit Sub
If Not Intersect(Target, Range("A1:B15")) Is Nothing Then
Set PlageTest = Range("A1:B15")
For Each Cell In PlageTest
If Cell.Interior.Color = vbRed Then
Total = Total + Cell.Value
End If
Next
Range("C1").Value = Total
End If
Fin:
End Sub