Re : comparer deux colonnes
Bonsoir,
Sinon, deux boucles imbriquées:
Option Explicit
Sub test()
Dim i, j As Integer
i = 1
Sheets(1).Cells.Font.Color = 4
While Sheets(1).Cells(i, 1) <> ""
j = 1
While Sheets(1).Cells(j, 2) <> ""
If Sheets(1).Cells(i, 1).Value =...