+ Reply to Thread
Results 1 to 2 of 2

Pivot Table - Conditional formatting Question

  1. #1
    Registered User
    Join Date
    04-04-2022
    Location
    Madrid, Spain
    MS-Off Ver
    Version 2022, Microsoft 365 for enterprise
    Posts
    1

    Pivot Table - Conditional formatting Question

    Hello!

    This is my first post here, please excuse if I'm missing a few information

    I have created a Pivot Table and want to format the sum of a margin with an icon based on another margin.
    So if margin B is between -5 and 5% of margin A, I get a green icon, between -5% and -10% and 5% and 10% yellow and above +-10%, I get a red icon.

    In the attached file, in the first row you see a "sum of budget IGM" of 29,9%. The "Sum of current IGM" is 39,6%. I would like create an icon in the "sum of current IGM" column that sets a color based on the rules above. Since the 39,6% are outside the (26,91%;32,98%) interval (+-10% of 29,9%), I want a red icon to appear.

    Excel.PNG

    Is this possible without creating another column with the difference between the two margins?
    Unfortunately, I am not sure, how to format these cells accordingly, could anyone help me out?

    I hope this is clear!

    Excited for the responses, thank you very much in advance for your help!

    Best regards,

    Julius

  2. #2
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    2,957

    Re: Pivot Table - Conditional formatting Question

    Welcome to the forum, Julius! Please attach your Excel workbook.

+ 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] Pivot Table Filter Formatting Question
    By jp16 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-28-2017, 03:42 AM
  2. Replies: 1
    Last Post: 12-08-2016, 03:14 PM
  3. Replies: 9
    Last Post: 03-07-2016, 10:39 AM
  4. Replies: 2
    Last Post: 09-04-2015, 02:47 AM
  5. Pivot Table question - formatting
    By c1steady in forum Excel General
    Replies: 6
    Last Post: 02-20-2012, 06:02 AM
  6. Pivot Table formatting question
    By mattbauer in forum Excel General
    Replies: 1
    Last Post: 02-23-2010, 07:59 PM
  7. Pivot Table Formatting Question
    By marmur1 in forum Excel General
    Replies: 3
    Last Post: 04-11-2005, 08:06 PM

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