Sub Test()
'Colorie en bleu les lignes contenant "MAUVAIS" pour isoler les soucis diélectriques fantômes
Cells.Interior.ColorIndex = xlNone
For i = Range("A" & Rows.Count).End(xlUp).Row To 2 Step -1
If Range("A" & i).Offset(, 2) Like "*MAUVAIS" Or Range("A" & i).Offset(, 3) Like "*MAUVAIS" Then
Range(Cells(i, 1), Cells(i, Range("A" & i).CurrentRegion.Columns.Count)).Interior.ColorIndex = 37
End If
Next
For i = Range("A" & Rows.Count).End(xlUp).Row To 2 Step -1
If Range("A" & i).Offset(, 2) Like "*BON" And Range("A" & i).Offset(, 3) Like "*BON" Then
Range(Cells(i, 1), Cells(i, Range("A" & i).CurrentRegion.Columns.Count)).Interior.ColorIndex = 4
End If
Next
End Sub