Conditional Formatting based on Cell References not Values

You could but if you look at my upload you will see you can do it with Vlookup therefore there shouldn't ever be any mistakes. You could use Address(), Row() and Column() to check if you were so inclined. I see you trying to reduce errors but if you use index() or vlookup() user mistakes shouldn't come into it.