Hi All, I know there is the highlight duplicates in conditional formatting but can that be adapted to work over two workbooks.