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
|
Option Explicit
Sub ModifierCouleur()
Dim AireDate As Range, Cellule As Range
Dim DerniereLigne As Long
Dim MonDico As Object
With Sheets("Feuil1")
DerniereLigne = .Cells(.Rows.Count, 2).End(xlUp).Row
Set AireDate = .Range(.Cells(2, 2), .Cells(DerniereLigne, 2))
AireDate.Offset(0, 1).Interior.ColorIndex = xlNone
End With
For Each Cellule In AireDate
If Cellule.Offset(0, -1) <> "" Then
Set MonDico = CreateObject("Scripting.Dictionary")
End If
If Cellule <> "" Then
If Not MonDico.Exists(Cellule.Value) Then
MonDico.Add Cellule.Value, Cellule.Value
Cellule.Offset(0, 1).Interior.Color = RGB(255, 255, 0)
Else
Cellule.Offset(0, 1).Interior.Color = RGB(255, 0, 0)
End If
End If
Next Cellule
Set MonDico = Nothing
End Sub |
Partager