I am having problems figuring out how to use Conditional Formatting in a case where I want cell values to be compared to values stored in another table and "linked" by a common field between the 2 tables.

Such as:

Table A

   Field A

   Field B

   Field C

   Field D

Table B

   Field A

   Field B

   Field C

   Field D

My grid uses Table A, and all it's fields.

But I want Field C and D Conditionally formatted based off Table B, Field C and D.

Table A, Field B holds Table B, Field A's value to link the two tables.

I want to set the background color of Table A, Field C to light green if Table A, Field C is between 90% and 95% of Table B, Field C, and set it to Dark Green if Table A, Field C is 95%-100% of Table B, Field C.

Same goes with Field D of both tables.

This needs to be done on a row by row basis I guess.

I'm not sure how to implement this.