6 Replies Latest reply: Jul 13, 2011 9:27 PM by Daniel Rozental RSS

    conditional formatting in pivot table not working

      I have a pivot table that shows qty, current month sales (MTD) and prior year month sales (PYMTD)

      and product line as dimension


      i have an expression that calculates growth % over prior year month sales. Example April 2011 Sales growth % over April 2010 Sales




      In Pivot table properties, Visual cues (Sheet) i set up the below:


      Green for my >=

      Black for normal

      Red for my <=



      but for some reason the color shown in the pivot table for Negative % growth is not consistant.

      Sometimes negatives show up as red and sometimes they show up as green, when all Negative growth % should be RED.



      For posative growth the same issue, some posative % show up as Red and some show up as Green when, all Posative growth % should show as GREEN.



      I have attached a recreation of the pivot table described


      Message was edited by: Joseph Bustos