Results 1 to 7 of 7

Conditional formatting in pivot table

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-05-2011
    Location
    India
    MS-Off Ver
    Excel 2013
    Posts
    243

    Conditional formatting in pivot table

    Hi All,

    I need your help to create conditional formatting in pivot table when it meets below condition.

    1) Highlight in green color when the Oppurtunity Section in col B and Parent sector in columns F till AH match.

    2) It should highlight color when the data in column are expanded.

    Attached is the example I tried. But the conditional formatting doesn't work when the rows are expanded.

    Please see attached and help to find solution.

    Regards,
    Vijay
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Pivot table & conditional formatting maybe???
    By thursday140 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-07-2013, 02:48 PM
  2. Conditional Formatting in Pivot Table
    By kimberlyre2000 in forum Excel General
    Replies: 0
    Last Post: 12-04-2012, 03:15 PM
  3. [SOLVED] Pivot Table - Conditional Formatting
    By lewny1983 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-27-2012, 04:51 AM
  4. Pivot Table conditional formatting using VBA
    By Leonprivatemail in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-28-2010, 08:58 AM
  5. Pivot Table Conditional Formatting
    By reagent in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-14-2008, 03:35 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