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 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
| Sub mise_en_forme()
'Mise en forme conditionnelle
'=================================================
For i = 10 To 23
With Range("A" & i)
.FormatConditions.Add Type:=xlCellValue, Operator:=xlEqual, _
Formula1:="=""OK"""
.FormatConditions(.FormatConditions.Count).SetFirstPriority
With Range(Cells(i, 1), Cells(i + 1, 1))
.FormatConditions(1).Interior
.PatternColorIndex = xlAutomatic
.color = 5296274 'vert clair
.TintAndShade = 0
End With
.FormatConditions(1).StopIfTrue = False
.FormatConditions.Add Type:=xlCellValue, Operator:=xlEqual, _
Formula1:="=""New_key"""
.FormatConditions(.FormatConditions.Count).SetFirstPriority
With Range(Cells(i, 1), Cells(i + 1, 1))
.FormatConditions(1).Interior
.PatternColorIndex = xlAutomatic
.color = 14470546 'bleu ciel
.TintAndShade = 0
End With
.FormatConditions(1).StopIfTrue = False
.FormatConditions.Add Type:=xlCellValue, Operator:=xlEqual, _
Formula1:="=""Not_ok"""
.FormatConditions(.FormatConditions.Count).SetFirstPriority
With Range(Cells(i, 1), Cells(i + 1, 1))
.FormatConditions(1).Interior
.PatternColorIndex = xlAutomatic
.color = 255 'rouge
.TintAndShade = 0
End With
.FormatConditions(1).StopIfTrue = False
.FormatConditions.Add Type:=xlCellValue, Operator:=xlEqual, _
Formula1:="=""Deleted"""
.FormatConditions(.FormatConditions.Count).SetFirstPriority
With Range(Cells(i, 1), Cells(i + 1, 1))
.FormatConditions(1).Interior
.PatternColorIndex = xlAutomatic
.color = 49407 'orange
.TintAndShade = 0
End With
.FormatConditions(1).StopIfTrue = False
End With
'Cells(i + 1, 1).Interior.color = Cells(i, 1).Interior.color
i = i + 1
Next i
end sub |
Partager