For lig = 1 To Range("A65536").End(xlUp).Row
If Range("A" & lig).Interior.ColorIndex = 2 Then
Range("C" & lig).Value = Range("A" & lig).Value
Else: Range("C" & lig).Value = Range("A" & lig).Value
End If
Next
Private Sub afficher()
If Columns("L:L").Interior.ColorIndex = 1 Then
Columns("N:N").Value = Columns("L:L").Value
Else: Columns("M:M").Value = Columns("L:L").Value
End If
End Sub
If Range("A" & lig).Interior.ColorIndex = 2 Then
oui bien vueChouette avatar (tu l'as changé non?)
For lig = 1 To Range("A65536").End(xlUp).Row
If Range("A" & lig).Interior.ColorIndex = 2 Then
Range("C" & lig).Value = Range("A" & lig).Value
Else: Range("C" & lig).Value = Range("A" & lig).Value
End If
Next