+ Reply to Thread
Results 1 to 2 of 2

Formatting row labels in Pivot tables

  1. #1
    Forum Contributor
    Join Date
    09-30-2009
    Location
    Barcelona
    MS-Off Ver
    Excel 2010
    Posts
    274

    Exclamation Formatting row labels in Pivot tables

    hi,

    I would like to color cells corresponding to labels of row fields in a pivot table
    and I would like that they keep it's coloring so that the user can filter to something else and when it comes back to the original filter the cell is colored again.

    With some trial I see that this works for cells with numbers, but not with text?

    is there any workaround?

    anyone tried before?

    I guess if it's not possible at user-level, I'll have to keep a hidden table with all the coloring needed and at every pivot table refresh go through the table and color the cells again... any better approach?

    Thanks!!

  2. #2
    Forum Contributor
    Join Date
    09-30-2009
    Location
    Barcelona
    MS-Off Ver
    Excel 2010
    Posts
    274

    Re: Formatting row labels in Pivot tables

    OK,

    so I guess it's not possible in a non-vba way

    thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Using Row Labels from Pivot Tables into VBA code
    By excelater in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-19-2016, 06:11 AM
  2. Row Labels - Pivot Tables
    By rickettsd96 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-22-2016, 08:45 AM
  3. Modify Row Labels on Multiple Pivot Tables
    By bhenlee in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-18-2015, 04:57 PM
  4. Pivot tables and labels
    By muminek in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-25-2012, 04:16 PM
  5. Pivot Tables - Listing Filtered Labels
    By learning_vba in forum Excel General
    Replies: 0
    Last Post: 06-13-2011, 03:50 PM
  6. [SOLVED] Pivot Tables and Column Labels
    By Mark McDonough in forum Excel General
    Replies: 2
    Last Post: 06-08-2006, 10:10 AM
  7. Replies: 2
    Last Post: 04-05-2006, 11:50 AM

Tags for this Thread

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