1 Answer Found

You don't need VBA for this, just conditional formatting. Let's saytable 1 is A1:A100 and table 2 is B1:B50. Highlight all of table 1 (FromB1 to B50) and go to the conditional formatting dialogue. Change it fromcell based to formula based and enter the formula: