JoeM wrote:
I have a number of ids in two columns and am trying to represent which ones
in the second column also appear in the first.

Assuming your two columns are A and B, select column B and enter this for
conditional formatting:

=COUNTIF($A:$A,B1)0

Select the format you want to "represent" matches.