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

    Colour scale using multiple if functions

    Bob Smaling

      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…