Data Validation allows you to pull data from one sheet into another, and then sort it with a drop down menu. It allows you to quickly and easily view data.
PATH: Format >> Conditional formatting
Mention the cell range where you want the conditional formatting
Select the format rules: it can be simple condition or use formula
The below sheet is view only mode, please make a copy to practice.