none
Pivot Table Styles Values with different Banded Row as the rest of the Pivot Table RRS feed

  • Question

  • Is there a way to do this? 

    e.g. to have the values in excel pivot table highlighted to be in different colour

    • Edited by Saputz Tuesday, December 1, 2015 6:04 PM a
    Tuesday, December 1, 2015 6:02 PM

Answers

  • Hi Saputz,

    For this requirement, you could set background color for specify range.

    For example:

    Dim pt As PivotTable
    Dim field As PivotField
    Set pt = PivotTables(1)
    Set field = pt.PivotFields("Sum of Age")
    field.DataRange.Select
    With Selection.Interior
            .Pattern = xlSolid
            .PatternColorIndex = xlAutomatic
            .Color = 65535
            .TintAndShade = 0
            .PatternTintAndShade = 0
        End With

    Regards

    Starain


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Wednesday, December 2, 2015 7:39 AM
    Moderator