5 Replies Latest reply on Jul 5, 2013 10:45 AM by Kris Erickson

    Conditional Formatting per cell by calculation

    David Joedicke

      Dear all,


      I have a question to the calculated fields. In my analyses I want to colour all cells of a spcific column green which are 10 % higher then the 14-days-average and all cells of that column that are 10 % below that line in red. It is no problem for me to get the 14-days-average and colour all cells in that row, but I just want that one cell to be coloured.


      Maybe an example makes it easier to understand:


      I have different departments and their sales per day. Now I want to show in which department at which date the sales per day are higher or lower than  the 10 % of the 14-days-average, by colour these cells different.


      I hope this is enough, if not please let me know what you need.


      Thank you for your help