EC

You need to watch the videos about Pivot tables and the tutorial about conditional formatting .

Video 1 (Conditional Formatting 1):  https://screencast-o-matic.com/watch/cYfFVLzzMe

Video 2 (Conditional Formatting 2):  https://screencast-o-matic.com/watch/cYfbVMzu0P

Video 3 (Pivot Tables):  https://screencast-o-matic.com/watch/cYfbeUzuKv