+ Reply to Thread
Results 1 to 2 of 2

How to use pivot field data as rule for conditional formatting??

  1. #1
    Registered User
    Join Date
    12-15-2020
    Location
    Amsterdam
    MS-Off Ver
    2016
    Posts
    3

    How to use pivot field data as rule for conditional formatting??

    Hi everyone,

    Hope you can help out with this.
    I want to mark data in a color, based on the data in another pivot field.

    In my example I would love Pivot Field (COLOR) to be highlighted when Pivot Field (TYPE) has the value "SPECIAL". So basically any data with the (TYPE) as "SPECIAL" needs to be highlighted.


    - Can we do this in a way, that still allows me to use filters and change the pivot table. So (TYPE) does not have to be a specific column. Prefer to keep it in the pivot field list.
    - Can we do this without access to the source data? Can't edit as on secure server.


    Thank you!
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2504
    Posts
    19,403

    Re: How to use pivot field data as rule for conditional formatting??

    The closest that I can come to what you want is:
    1. Convert the Data sheet to an Excel table > tbl_Style
    2. Add the table to the data model
    3. Add the following measure (Color text) to the data model: =CONCATENATEX(tbl_Style,[COLOR],",")
    4. In the pivot table pull Style, Color and Type into the Rows area
    5. Pull Color text and Units into the values area
    6. The following is the conditional formatting rule applied to All cells showing "color text" values for "Type": =G7="special"
    7. The Color and Type columns are hidden
    8. A slicer is used to choose the Type to be displayed
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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: 2
    Last Post: 12-19-2022, 10:43 PM
  2. Conditional Formatting Pivot Table based on field Names
    By snikrs in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-25-2018, 05:17 PM
  3. Conditional formatting on pivot field header
    By dgharvey in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-13-2013, 08:25 AM
  4. Conditional Formatting Pivot Tables/Calculate Field Lists
    By smithj96 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-23-2013, 08:54 AM
  5. Conditional formatting rule need help
    By Kagesen in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-25-2011, 04:42 AM
  6. Conditional Formatting of Pivot Table Field
    By jdanderson02 in forum Excel General
    Replies: 2
    Last Post: 02-09-2006, 04:45 PM
  7. pivot tables-data field formatting
    By popp25 in forum Excel General
    Replies: 3
    Last Post: 03-16-2005, 11:06 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