0 Replies Latest reply: Apr 3, 2018 9:40 AM by John Murphy RSS

    Can I filter a table by background colour?

    John Murphy

      I have a table of data where I have created an expression for the background colour of the cell to turn Red if a certain word appears in the cell

       

       

      However.  I would like to know if there is a way I can filter to see just the highlighted cells in the column.

       

      Also, is there a way I can stop losing my place in the table when switching between sheets?  If I scroll down this column, view a different sheet then come back to it, it automatically takes me back to the top of the table.

       

      Any help would be appreciated.