Private Sub Worksheet_Change(ByVal Target As Range)
If WorksheetFunction.CountBlank(Range("A" & [Debut].Row & ":" & "A" & [Fin].Row)) <= 3 Then
Shapes("Insertion").OLEFormat.Object.Interior.Color = 49407 ' orange
Else
Shapes("Insertion").OLEFormat.Object.Interior.Color = 16507848 ' bleu clair
End If
End Sub