How to filter data and highlight discontinuous cells?

[chanwj]

Hello, is there any way to achieve those two effect?

1. Filter data based on conditions(with no dropdown box). For example, get all the cells in the first column which cell content equals to "target string".
2. Highlight a collection of specifc cells which are not continuous(not like span). For example, after filtering data(just like the above situation), I got two cells(A1 and A6), then I need to change their background into green.

Thanks!