3 Replies Latest reply on Nov 23, 2018 8:44 AM by Paul Wachtler

    Can you colour only half the table?

    Sander Binda



      I've added a screenshot of my current workbook.

      I made a selection of fruit and split them into rotten and not rotten.

      Both show absolute numbers and the percentages.

      Now I want to colour the squares only of the rotten ones.


      The issue I have is that when I filter only on the rotten ones my percentages go to 100%, is there a way to keep the percentages as they are?