+ Reply to Thread
Results 1 to 1 of 1

Different colouring in a pivot table

  1. #1
    Registered User
    Join Date
    11-15-2012
    Location
    Toronto, Canada
    MS-Off Ver
    MS Excel 365
    Posts
    49

    Different colouring in a pivot table

    Hi Forum,

    I have a pivot table with 12 months of worth of data (each month are laid out, and also have a quarterly sum). Is there a way that I can colour Q1, Q2, Q3, Q4 separately, into its own colour?

    I am laying it out to show some numbers so the overwhelming number of columns aren't too difficult to read.

    Let me know. Something that I am looking for is to designate specific fields (ie. January, February, March, Q1 2014 fields and anything related to it will have the colour green even if it's part of a calculated field within a pivot, I want it to automatically update).

    Thanks in advance.
    Last edited by swchoi89; 01-17-2014 at 10:57 AM.

+ 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. Collapse/Expand - Pivot table Fields - Need equivalent option in Excel VBA Pivot table
    By ragavendraph in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-07-2012, 03:00 PM
  2. Replies: 1
    Last Post: 06-22-2010, 09:10 AM
  3. Replies: 1
    Last Post: 06-20-2010, 04:00 AM
  4. [SOLVED] Create Pivot Table: Cannot Open Pivot Table Source File
    By jomili in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 01-05-2010, 05:11 AM
  5. Return pivot table range...not the data table, the PIVOT TABLE!
    By Air_Cooled_Nut in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-26-2008, 01:07 PM

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