J'ai trouvé un solution vos avis ?
Set IDColumn = ws.UsedRange.Find("ID", , xlValues, xlWhole)
Set FRColumn = ws.UsedRange.Find("FR", , xlValues, xlWhole)
Set ENColumn = ws.UsedRange.Find("EN", , xlValues, xlWhole)
Set ESColumn = ws.UsedRange.Find("ES", , xlValues, xlWhole)
Set PLColumn = ws.UsedRange.Find("PL", , xlValues, xlWhole)
Set PTColumn = ws.UsedRange.Find("PT", , xlValues, xlWhole)
derniere_ligne = ws.Cells(1, IDColumn.column).End(xlDown).Row
Range(Cells(2, ENColumn.column).Address(), Cells(derniere_ligne, PTColumn.column).Address()).Select
Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlEqual, _
Formula1:="=$" & Split(Cells(1, FRColumn.column).Address, "$")(1) & "2"
Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority
With Selection.FormatConditions(1).Interior
.PatternColorIndex = xlAutomatic
.Color = 15773696
.TintAndShade = 0
End With
Selection.FormatConditions(1).StopIfTrue = False