J'ai donc rajouté un peu de code, cependant tous les onglets contenant tcd deviennent rouge alors que j'ai inséré "ActiveSheet.Tab.Color = vbRed" dans le If.
Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)
Dim n As Long, lCol As Long, lColEnd As Long
For Each ws In ActiveWorkbook.Worksheets
If Left(ws.Name, 4) = "tcd " Then
With Target
.DataBodyRange.Cells.Interior.ColorIndex = xlColorIndexNone
n = .TableRange1.Cells(.TableRange1.Cells.Count).Row
lColEnd = .TableRange1.Columns.Count
For lCol = 2 To lColEnd
If Cells(n, lCol) < Cells(n - 1, lCol) Then
Cells(n, lCol).Interior.ColorIndex = 3
ActiveSheet.Tab.Color = vbRed
End If
Next
End With
End If
Next ws
End Sub
EDIT : d'ailleurs pas que les onglets contenant "tcd" mais dès que je clique sur un onglet.
Cdt,
Monak08