25 Replies Latest reply: Oct 2, 2015 6:35 AM by Dennis Hoogenboom RSS

    Background Color Pivot chart (if one dimension on top)

    Sabrina Richter

      Hi all,

       

      I created a pivot chart and want to highlight every second row. So I gave every formula and dimension a background formula as followed:

      =if(mod(rowno(),2)=0,LightGray(80))

       

      Is it possible to give the cells in red a background color?

      Thanks a lot!