I have been working with Excel for over 10 years, and conditional formatting based on another cell is one of those features I use almost every single week. Let me walk you through all five methods, step by step.
https://excelchamps.com/excel-basics/conditional-formatting-another-cell/