Results 1 to 7 of 7

Border of cells around pivot table

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    4,065

    Border of cells around pivot table

    I have a pivot table that's refreshed every time the sheet is activated. The design desired on the PT sheet is to have the cells around the pivot to be green, while the pivot remains uncolored, and the rest of the sheet other than the green border stays uncolored (or, stays the various colors it is). I've included an example of the desired result.

    The problem is that, depending on the PT's source data, the pivot can be only a few rows deep, or many rows deep. Adding or removing a field, or changing the number of rows, changes where the green should be, so I need a macro tha can keep up with it. Can anyone point me in the right direction?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1