+ Reply to Thread
Results 1 to 2 of 2

Can I conditionally format pivot chart totals?

Hybrid View

  1. #1
    Registered User
    Join Date
    12-19-2007
    Posts
    24

    Can I conditionally format pivot chart totals?

    Hello all,

    I have a pivot table in which I would like to conditionally format the Total rows. I can use the Fill Color tool to give all Total Rows for a field to a certain color. I double click on the total field and it highlights all Total rows for that field so I just have to do the color fill once and it works for all of them. If the data changes when the chart is refreshed the Total Rows maintain their color even if they move.

    Problem is I would like to conditionally format the Total Rows. It works great when I double click the field for that Total Row and do my condition and pick a color. I can pick one row and it will fill in the corresponding Totals for that field down the pivot table. However, if the data changes the conditional formatting does not follow the total row around like it does for the regular Fill Color Totals.

    Is it possible to use conditional formatting instead of Fill Color for pivot tables?

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481

    Re: Can I conditionally format pivot chart totals?

    I think you would need code to update the under lying cells in the table.
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

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