A couple things in response to this -
First of all, Airtable has no concept of coloring a “cell”, so I’m assuming you are referring to coloring a “record” (Airtable puts a little colored bar on the left side of the record’s primary field (usually “Name”).
I assume Table A and Table B are linked in some way? If you have a field linking a record from Table A to a record from Table B, you can do this by pulling the field you need to check against from Table A into Table B with a Lookup field. Next, you’ll need a formula to check for the intended version from Table B to see if it exists in all the linked records from Table A. Then, you can base your color field on that final formula.
SEARCH() returns blank if the string is not found in the source, so the color check looks for “Empty” or “Not Empty” to determine if the versions match. You need that little
&"" at the end of the
SEARCH() formula to convert the value in the Lookup field from an array to a string.
Hopefully that helps - let me know if you need further clarification.