Hello Everyone,
I have a pivot table that contains a Conditional Formatting, this formatting puts the cells white to red. I have a VBA Code which will count the cells but inside the pivot table not recognizes the count of the red cells.
This is the Code i´m using. I need your help
Thank you!
Function ColorFunction(rColor As Range, rRange As Range, Optional SUM As Boolean)
Dim rCell As Range
Dim lCol As Long
Dim vResult
lCol = rColor.Interior.ColorIndex
If SUM = True Then
For Each rCell In rRange
If rCell.Interior.ColorIndex = lCol Then
vResult = WorksheetFunction.SUM(rCell, vResult)
End If
Next rCell
Else
For Each rCell In rRange
If rCell.Interior.ColorIndex = lCol Then
vResult = 1 + vResult
End If
Next rCell
End If
ColorFunction = vResult
End Function
Bookmarks