Border of cells around pivot table

HI jomili,

Pivot can grow only downwards or towards right as well ?

I believe you can use conditional formatting using offset / defined names to obtain green boarder and after that it all untouched cells.


Regards,
DILIPandey
<click on below * if this helps>

perhaps name the green area around the pivot table (including the pivot table itself) "pivotBorder" then add this code to the sheet

Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)
    Const csRANGENAME As String = "pivotBorder"
    On Error Resume Next
    Me.Range(csRANGENAME).Interior.ColorIndex = xlColorIndexAutomatic
    On Error GoTo 0
    With Target.TableRange1
        With .Offset(-2, -1).Resize(.Rows.Count + 8, .Columns.Count + 2)
            .Name = csRANGENAME
            .Interior.Color = 1242669
        End With
        .Interior.ColorIndex = xlColorIndexAutomatic
    End With
End Sub

The offset is declaring the point in which to start the resize function.

So, if you're table starts at C3, the offset is telling you to go to A2, and then add in the rows (+8) and all the columns (+2)... This is basically setting how far up and how far to the left the border starts.

Hope that helps!