Bonjour,
Désolé, j'avais juste fais une mise en gras sur la première colonne donc, voici le code corrigé :
Sub Test()
Dim Plage As Range
Dim Cel As Range
Dim Adr As String
With Worksheets("Feuil1")
Set Plage = .Range(.Cells(2, 1), .Cells(.Rows.Count, 1).End(xlUp))
Set Cel = Plage.Find("Total", , xlValues, xlPart)
If Not Cel Is Nothing Then
Adr = Cel.Address
Do
.Range(Cel, Cel.Offset(, 7)).Font.Bold = True
.Range(Cel, Cel.Offset(, 7)).Interior.Color = 15652540
Set Cel = Plage.FindNext(Cel)
Loop While Cel.Address <> Adr
End If
End With
End Sub