Use more advanced custom formulas with 2 or more criteria in conditional formatting and filters with your data. This is a great way to find the rows that match several criteria and highlight only them or even filter your data by those 2+ criteria to show only the matching rows.
Make a copy of the demo sheet and follow along: https://doittraining.page.link/democo...
Slides: https://doittraining.page.link/condit...