1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40
| Sub Module15Couleurs()
Dim i As Long
Dim nb As Integer
Dim j As Integer
Dim intCouleur As Integer
Dim rg As Range
intCouleur = 1
i = 1
'!!mettre en col Z couleurs recherchées:6,8,10,12,14,16,18,20,22,24,26,28,30,34,35,36,37,38,39,40,42,43,44,45,46,50
Do While Range("G" & i).Value <> ""
nb = Application.WorksheetFunction.CountIf(Range("G" & i & ":G64000"), Range("G" & i).Value)
If nb > 1 And Range("H" & i).Interior.ColorIndex = xlNone Then
Range("A" & i & ":H" & i).Interior.ColorIndex = Range("Z" & intCouleur).Value
For j = 1 To nb - 1
If j = 1 Then
Set rg = Range("G:G").Find(Range("G" & i).Value, Range("G" & i), , , , xlNext)
Else
Set rg = Range("G:G").FindNext(rg)
End If
Range("A" & rg.Row & ":H" & rg.Row).Interior.ColorIndex = Range("Z" & intCouleur).Value
Next j
intCouleur = intCouleur + 1
End If
i = i + 1
Loop
End Sub |
Partager