Related Post: How To Use Vlookup In Conditional Formatting Can I Use A Vlookup In Conditional Formatting