Private Sub Worksheet_Activate()
Jour = Date
Dim Cel As Range
Dim myRange As Range
Set myRange = Range("B7:B7") 'Plage de données concernée à modifier
For Each Cel In myRange
If Jour - Cel.Value > 15 Or Jour - Cel.Value = 15 Then
Cel.Offset(0, 1).Interior.ColorIndex = 3
End If
Next Cel
End Sub