Different Color coding in the same cell content based on value from other table

Hi

Is it possible to color code the same cell content based on value from other table?

For example, I would like to color code Table A "Site" column based on status from "Table B" for each site i.e. "Completed" status should be in "Green", In Progress Status should be in Blue and Not Started Status should be in Red.

Table A:

Table B:

Expected Result:

Table A