Using conditional formatting to find duplicate values in two tables.

[jbake248]

Hello, I search the site and could not find this answer. I'm working with Access and I have two tables each having a column with the same information, I want to use conditional formatting to find the duplicates.
This is what I'm using in the expression part of a new rule. =countif( [Review]![Table1]= [Table2]![Case Number],0).

What I get is you may have entered a comma without a preceding value or identifier. I have no commas in the expression.
Any help would surely be appreciated.

 

[jbake248]

Perfect thanks for all your help. I cannot get the formatting to work but with the query, I'm not sure I need it.

 

[Joe4]

Perfect thanks for all your help. I cannot get the formatting to work but with the query, I'm not sure I need it.

Yes, since you can limit your query to only those records you are interested in, I thought that might not be necessary.