I’m always forgetting the syntax and also here’s some tricks.

1. How to highlight cells based on another cell’s value in Excel 2011 – Ask Different
2. Format cell color based on value in another sheet and cell – Stack Overflow
3. Conditional format cells based on match in another sheet – Stack Overflow