Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Not Intersect(Target, Range("e4:e19")) Is Nothing Then
With ActiveCell.Offset(0, -4).Resize(1, 4)
.Font.Strikethrough = Not .Font.Strikethrough
ActiveCell = IIf(ActiveCell.Offset(0, -4).Font.Strikethrough, "Oui", "Non")
End With
With ActiveCell
If .Offset(0, -4).Font.Strikethrough = True Then
.Interior.ColorIndex = 35
.Font.ColorIndex = 3
Else
.Interior.ColorIndex = 36
.Font.ColorIndex = 5
End If
End With
If Target.Offset(0, -1) = vbNullString Then
Target.Offset(0, 0).Interior.Color = vbYellow
Target.Offset(0, 0).ClearContents
End If
End If
Cancel = True
End Sub