11 Replies Latest reply: Jun 5, 2013 5:12 AM by Gysbert Wassenaar RSS

    Expression based on a 2nd IF Color condition data problem

    Simon Goodman

      I have one block of data with various format styles (e.g 0, 0.0, 0.0%) so I have used IF to build the expression in a pivot table. I also want to add  an IF colour condition to Background Color but it is based on a second block of data.

       

      I can get it to work if the expression is a simple Sum(Data) expression but not when I apply IF to apply formatting. Are there any ideas how to solve this problem?