+ Reply to Thread
Results 1 to 2 of 2

Pivot table conditional formatting on one total column but applies itself to all columns

  1. #1
    Registered User
    Join Date
    02-18-2013
    Location
    Hamilton, New Zealand
    MS-Off Ver
    Excel 2010
    Posts
    13

    Pivot table conditional formatting on one total column but applies itself to all columns

    Hi Forum

    When I conditional format the subtotal column in a pivot table it goes and applies the same conditional format to the other columns being subtotaled.

    See attached screen shot, the subtotal column for 2013 (column V) should be conditionally formatted not the other columns (columns M to T).

    this conditional formatting is applied via VBA code however if i apply it manually it does the same thing.

    VBA code used is as follows:

    Please Login or Register  to view this content.
    Basicly for cell V10 this is:

    =IF($V$10<$L$10,TRUE,FALSE) (True being Red or down on last years)
    and
    =IF($V$10>$L$10,TRUE,FALSE) (True being Green or up on last years)

    Once I have this working for one column i will also do similar on other columns but that is another story...

    Thanks,

    -Ollie
    Attached Images Attached Images

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Pivot table conditional formatting on one total column but applies itself to all colum

    Hi and welcome to the forum

    Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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