9 Replies Latest reply: May 12, 2014 6:21 AM by Jairaj Singh RSS

    Conditional colour formating in pivot table for Dimensions not working

    Vinod Ramachandra

      Hi..i have strange problem..i just want show the "Days" column of the attached file with Red background with following conditions

      1. When Days >= 30 days, Background color of Days Dimension should be red

      2.Dont change the table structure ..it should remain like that only

      3.in current file color is showing for some values which are > 30, for some other even if it is 120 days background color doesn't change.

       

      I have attached the file kindly help me

      thanks in advance