+ Reply to Thread
Results 1 to 4 of 4

Conditional Format of Pivot "Mind of its own"

  1. #1
    Registered User
    Join Date
    03-13-2020
    Location
    NYC
    MS-Off Ver
    16.0 32bit
    Posts
    7

    Conditional Format of Pivot "Mind of its own"

    Hello EF community,

    I am having an issue with conditional formatting of a pivot table. I generated a formula in my original dataset to generate a "FLAG" if certain criteria are met for 3 different scenarios - each with their own column. I included these in my pivot table, columns, W:Y, with the intent to highlight the entire row if any of the 3 columns trigger the "FLAG" input.

    I created 3 conditional formatting rules based on the input trigger of "FLAG" in cell AC2, yet the rule appears to only partially work (and select other non "FLAG" inputs simultaneously.

    I'm hoping its an easy fix and that I am making a simple mistake.

    For reference - though the pivot only reaches to around row ~1300, I set the parameter to row 1800 in the event my dataset becomes larger.

    Thanks in advance for your support!

    -Cobraman
    Attached Files Attached Files
    Last edited by cobraman; 05-12-2021 at 11:30 AM.

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,421

    Re: Conditional Format of Pivot "Mind of its own"

    Changing the three rules and the 'applies to' as follows seems to make the correct rows highlight:
    =$Y15=$AC$2
    =$X15=$AC$2
    =$W15=$AC$2
    All with a 'applies to' of: =$B$15:$Y$1800
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Registered User
    Join Date
    03-13-2020
    Location
    NYC
    MS-Off Ver
    16.0 32bit
    Posts
    7

    Re: Conditional Format of Pivot "Mind of its own"

    Worked Perfect - thank you JeteMC!

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,421

    Re: Conditional Format of Pivot "Mind of its own"

    You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.

+ 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. [SOLVED] Need assistance with "Pivot Table", "Slicer", and "Dynamic/Interactive Graph"
    By skydivetom in forum Excel Charting & Pivots
    Replies: 26
    Last Post: 06-27-2020, 11:03 AM
  2. Replies: 4
    Last Post: 04-04-2020, 12:00 PM
  3. Replies: 4
    Last Post: 03-02-2020, 02:08 AM
  4. [SOLVED] formula help: conditional format of one column based on "YES"/"NO" content of four others!
    By 10 Dollar Bill in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-20-2014, 01:59 PM
  5. Replies: 3
    Last Post: 01-02-2014, 02:15 PM
  6. Replies: 2
    Last Post: 06-06-2013, 12:45 PM
  7. [SOLVED] Keep conditional format when "show pages" from Pivot table
    By Angus in forum Excel General
    Replies: 7
    Last Post: 06-30-2005, 09:05 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