+ Reply to Thread
Results 1 to 5 of 5

Conditional Formatting within Pivot Table by Category

  1. #1
    Forum Contributor Grimace's Avatar
    Join Date
    05-04-2009
    Location
    Gold Coast, Australia
    MS-Off Ver
    Excel 2013 and Office 365 Plus
    Posts
    359

    Conditional Formatting within Pivot Table by Category

    Hi All

    I would like to know if it is possible to format a pivot table by category?

    I have a table which has data for Hours worked, and it is broken down by Paid and Unpaid with a number of different elements possible under each "Heading".

    I would like to use conditional formatting to make anything under the Heading "Paid" Green, and anything under the heading "unpaid" Orange.
    I have only been able to get the actual Heading Word to change, not any data that falls within that category.

    Any help would be greatly appreciated.
    Attached Files Attached Files
    Handy things to keep in mind:

    Click *, if my suggestion has helped you
    If your problem is solved, then please mark the thread as SOLVED

    Sharing is Caring .... spread the knowledge

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,267

    Re: Conditional Formatting within Pivot Table by Category

    Hi Grimace,

    If you can make your Unpaid values negative numbers it would be easy.
    Can you create a calculated item that turns those unpaid to negatives?
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Forum Contributor Grimace's Avatar
    Join Date
    05-04-2009
    Location
    Gold Coast, Australia
    MS-Off Ver
    Excel 2013 and Office 365 Plus
    Posts
    359

    Re: Conditional Formatting within Pivot Table by Category

    Hi MarvinP

    The data is brought in from an external source, so I would much prefer to work with what I have than to create a process requiring manual steps in between.
    The Data also contributes to overall worked time calculations, so converting it to a negative will not work.

    Warm regards
    Darren.

  4. #4
    Forum Contributor Grimace's Avatar
    Join Date
    05-04-2009
    Location
    Gold Coast, Australia
    MS-Off Ver
    Excel 2013 and Office 365 Plus
    Posts
    359

    Re: Conditional Formatting within Pivot Table by Category

    Any ideas on this one?

  5. #5
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,267

    Re: Conditional Formatting within Pivot Table by Category

    Hey Grimace,

    What if you change the design of the Pivot Table to Outline or Tab (not compact) and repeat the Labels. That way the word of Paid or Unpaid will show all the way down column B. Use CF on that column. Does that get you closer?
    Conditional Format within Pivot Design Repeated Row Labels.xlsx

+ 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. Replies: 1
    Last Post: 12-08-2016, 03:14 PM
  2. pivot table and conditional conditional formatting
    By Veronsito in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-07-2016, 12:15 PM
  3. Replies: 9
    Last Post: 03-07-2016, 10:39 AM
  4. Replies: 2
    Last Post: 09-04-2015, 02:47 AM
  5. Conditional Formatting in Pivot table using VBA
    By pdalal in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-05-2015, 04:01 PM
  6. Replies: 1
    Last Post: 02-04-2015, 10:33 PM
  7. Changing a pivot chart column color based on the pivot table category
    By Shawne in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-08-2014, 09:12 AM

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