formatting lookup VBA

by Rubin|Published August 10, 2023

I’m looking to copy the format of a cell within the table table1 to cells with matching text within the second table table2.

So for instance: NOT(H) is showing as green in table 1 and I want it to show as green in cell C2 in table 2. Is there a VBA that can do this?