Salut erni,
pas de souci...
Deux cellules :
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
'
If Not Intersect(Target, Union(Range("H3"), Range("H5"), Range("E5"))) Is Nothing Then
With Target
.Interior.Color = IIf(.Interior.Color = RGB(0, 176, 80), xlNone, RGB(0, 176, 80))
.Offset(IIf(.Row = 3, 2, -2), 0).Interior.Color = IIf(.Interior.Color = RGB(0, 176, 80), xlNone, RGB(0, 176, 80))
End With
End If
'
End Sub
Trois cellules :
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
'
If Not Intersect(Target, Union(Range("H3"), Range("H5"), Range("E5"))) Is Nothing Then
With Target
If .Column = 8 Then
.Interior.Color = IIf(.Interior.Color = RGB(0, 176, 80), xlNone, RGB(0, 176, 80))
.Offset(IIf(.Row = 3, 2, -2), 0).Interior.Color = IIf(.Interior.Color = RGB(0, 176, 80), xlNone, RGB(0, 176, 80))
.Offset(IIf(.Row = 3, 2, -2), -3).Interior.Color = xlNone
Else
.Interior.Color = RGB(0, 176, 80)
.Offset(0, 3).Interior.Color = xlNone
.Offset(-2, 3).Interior.Color = xlNone
End If
End With
End If
'
End Sub
A+