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