Sub FiltrerCouleur()
Dim w As Worksheet, plage As Range
Application.ScreenUpdating = False
For Each w In Worksheets
Set plage = Intersect(w.[A:A], w.UsedRange.EntireRow)
plage.AutoFilter 1, RGB(255, 255, 0), xlFilterCellColor 'filtre la couleur jaune
Set plage = plage.SpecialCells(xlCellTypeVisible)
w.AutoFilterMode = False
w.Rows("920:" & w.Rows.Count).Delete
plage.EntireRow.Copy w.Rows(920)
w.Rows(920).Delete
Next
End Sub