See this link: Get Around Excels 3 Criteria Limit in Conditional Formatting