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.