Option Explicit
Sub Rech_Valeurs()
Dim tab1 As Range, tab2 As Range, cel As Range, c As Range
With Application
.EnableEvents = False
.ScreenUpdating = False
.Calculation = xlCalculationManual
End With
With Feuil1
Set tab1 = .Range("b2:l21")
Set tab2 = .Range("o8:x21")
For Each cel In tab1
For Each c In tab2
If cel.Value = c.Value Then
cel.Value = c.Value
cel.Interior.Color = c.Interior.Color
End If
Next c
Next cel
End With
With Application
.EnableEvents = True
.ScreenUpdating = True
.Calculation = xlCalculationAutomatic
End With
End Sub