Sub ligne_couleur()
Dim i%
For i = Cells(Rows.Count, 1).End(xlUp).Row To 1 Step -1
If Cells(i, 1).Interior.ColorIndex = 5 Then '<-- adapter l'index
Rows(i).Select
Exit Sub
End If
Next i
End Sub
Sub ligne_couleur()
Dim i%
For i = Cells(Rows.Count, 1).End(xlUp).Row To 1 Step -1
If Cells(i, 1).Interior.ColorIndex = 5 Then '<-- adapter l'index
Cells(i, 1).Select
Exit Sub
End If
Next i
End Sub