Range("Y:Y").Select
Selection.FormatConditions.Delete
Selection.FormatConditions.Add Type:=xlExpression, Formula1:="=SI($O1<>"""";$Y1>=$O1;et($E1<>"""";$Y1>=$M1))"
Selection.FormatConditions(1).Interior.ColorIndex = 3
Selection.FormatConditions(1).Font.ColorIndex = 2
Selection.FormatConditions(1).Font.Bold = True
Range("F1006").End(xlUp).Offset(1, 0).Select
Range("Y:Y").Select
Selection.FormatConditions.Add Type:=xlExpression, Formula2:="=ET($E5<>"";$AA5="";$Y5<AUJOURDHUI())"
Selection.FormatConditions(2).Interior.ColorIndex = 6
Selection.FormatConditions(2).Font.ColorIndex = 1
Range("F1006").End(xlUp).Offset(1, 0).Select