For N = 2 To total
Range('C' & N & ':E' & N).Select
Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlEqual, _
Formula1:='=PETITE.VALEUR($C$' & N & ':$E$' & N & ';1)'
Selection.FormatConditions(1).Interior.ColorIndex = 50
Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlEqual, _
Formula1:='=GRANDE.VALEUR($C$' & N & ':$E$' & N & ';1)'
Selection.FormatConditions(1).Interior.ColorIndex = 3
Next