Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Application.Intersect(Target, Range('E6')) Is Nothing Then
Range('D6').Interior.ColorIndex = 4
End If
End Sub
code a mettre dans la feuille concernee:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If ActiveCell.Address = '$E$6' Then
Range('d6').Interior.ColorIndex = 3
Else
Range('d6').Interior.ColorIndex = none
End If