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

[vishalcmehta]

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:

ID	Site
1	News
2	News, Books
3	Books, Games, Sports

Table B:

Site	Status
News	Completed
Books	In Progress
Games	Not Started
Sports	Completed

Expected Result:

Table A

ID	Site
1	News
2	News, Books
3	Books, Games, Sports

[Greg_Deckler · Accepted solution]

No, not like that with multiple colors in the same cell.