Compare and highlight differences in Excel
Let’s say you have List A and List B, both starting in A2 and B2
In C2, enter this:
=IF(COUNTIF($B$2:$B$14, A2)=0, A2, "")
Drag-copy that down column C as far as needed.
If it appears in List A, but not in List B, it shows in Col C.