Sub Mise_en_forme_conditionnelle()
Dim Tableau, plage1 As Range
Dim rngETA As Range
Set plage1 = Range("Tableau2")
Set Tableau = Range("Tableau2")
Set rngETA = [ETA].Rows(1).Address(False, True)
Tableau.Select
Selection.FormatConditions.Delete
'Lignes en vert 35 si ETA <>""
With plage1.Select
plage1.FormatConditions.Add Type:=xlExpression, Formula1:="=" & rngETA & "<>0"
plage1.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority
With Selection.FormatConditions(1).Interior
.ColorIndex = 35
End With
plage1.FormatConditions(1).StopIfTrue = False
End With
End Sub