4 Replies Latest reply: Mar 30, 2016 7:46 AM by bruno bertels RSS

    Colour scale using multiple if functions

      Hi all,


      I want to at a colour scale from light to dark for the highest value to the lowest value on my pivot table

      Is it possible to use a multiple if function or can i use an other function for this


      if(hrank(sum([Totaal omzet 2016]))=1,green()),if(hrank(sum([Totaal omzet 2016]))=2,ligt green()) etc…