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

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.