Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo fin
If Target.Column = 9 Then
Cells(Target.Row, 1).Resize(, 9).Interior.ColorIndex = 43
Cells(Target.Row, 18).Resize(, 4).Interior.ColorIndex = 43
Else
Cells(Target.Row, 1).Resize(, 9).Interior.ColorIndex = -43
Cells(Target.Row, 18).Resize(, 4).Interior.ColorIndex = -43
End If
If Target.Column = 15 Then
Cells(Target.Row, 11).Resize(, 5).Interior.ColorIndex = 10
Else
Cells(Target.Row, 11).Resize(, 5).Interior.ColorIndex = -10
End If
For chiffre = 323 To 999
For lettre = 1 To 30
If Cells(chiffre, lettre).Value Like "*faire *" Then
ActiveCell.Interior.Color = 0
ActiveCell.Font.ColorIndex = 3
End If
If Cells(chiffre, lettre).Value Like "*urgent *" Then
ActiveCell.Interior.Color = 43
ActiveCell.Font.ColorIndex = 3
End If
fin:
End Sub