I’m also going to link my solution here in case someone finds this thread
It doesn’t highlight duplicates with conditional formatting or any other live recalculation but does so in manually run passes. And provides some gorgeous UI for resolving those duplicates:
