Sub Comparer()
Dim WbS As Workbook, WbC As Workbook
Dim WsS As Worksheet, WsC As Worksheet
Dim PlageC As Range, PlageS As Range, Cel As Range, C As Range
Set WbC = Workbooks("Fichier1")
Set WbS = Workbooks("Fichier2")
Set WsC = WbC.Worksheets("Check PC MEP-APA")
Set WsS = WbS.Worksheets("Sheet1")
Set PlageC = WsC.Range("C2:C" & WsC.Range("C" & Rows.Count).End(xlUp).Row)
Set PlageS = WsS.Range("C2:C" & WsS.Range("C" & Rows.Count).End(xlUp).Row)
Application.ScreenUpdating = False
For Each Cel In PlageC
Set C = PlageS.Find(Cel, , xlValues, xlWhole)
If Not C Is Nothing Then
C.EntireRow.Copy Cel.EntireRow
Cel.EntireRow.Font.ColorIndex = 3
End If
Next Cel
Application.ScreenUpdating = True
End Sub