Watch this tutorial to learn how to use filters and udpdate conditional formatting:
Check out the tutorial above.