Salut les gars.
Merci de vos reponses, ça marche niquel.
Seul petit truc, c'est que je sui obligé de mettre ceci:
Do While ActiveCell <> ""
If ActiveCell.Value Like "*Auto*" Then
ActiveCell.Interior.Color = RGB(0, 120, 210)
End If
If ActiveCell.Value Like "*auto*" Then
ActiveCell.Interior.Color = RGB(0, 120, 210)
End If
If ActiveCell.Value Like "*Moto*" Then
ActiveCell.Interior.Color = RGB(153, 0, 153)
End If
If ActiveCell.Value Like "*moto*" Then
ActiveCell.Interior.Color = RGB(153, 0, 153)
End If
If ActiveCell.Value Like "*Habitation*" Then
ActiveCell.Interior.Color = RGB(252, 179, 48)
End If
If ActiveCell.Value Like "*habitation*" Then
ActiveCell.Interior.Color = RGB(252, 179, 48)
End If
If ActiveCell.Value Like "*Santé*" Then
ActiveCell.Interior.Color = RGB(164, 247, 53)
End If
If ActiveCell.Value Like "*santé*" Then
ActiveCell.Interior.Color = RGB(164, 247, 53)
End If
If ActiveCell.Value Like "*Vie*" Then
ActiveCell.Interior.Color = RGB(226, 0, 0)
End If
If ActiveCell.Value Like "*vie*" Then
ActiveCell.Interior.Color = RGB(226, 0, 0)
End If
ActiveCell.Offset(0, 1).Select
Loop