Bonjour, toutes feuilles sauf "General"
Sub Macrotoutesfeuilles()
Application.ScreenUpdating = False
Dim wSht As Worksheet
For Each wSht In Worksheets
If wSht.Name <> "General" Then
Set Plage = .Range("C3:G20")
For Z = 22 To 31 Step 1
For Each cell In Plage
cell.Select
If cell.Value = Cells(Z, 1).Value Then Selection.Interior.Color = F1.Cells(Z, 1).Interior.Color
If cell.Value = Cells(Z, 1).Value Then Selection.Font.Color = F1.Cells(Z, 1).Font.Color
Next
Next Z
End If
Next
Application.ScreenUpdating = True
End Sub