Highlighting duplicate values in a column in conjunction with active cell

Hi,

I'm using this code to highlight the row of an active cell and would like to add to it so that duplicate values of the selected cell in column B are also highlighted

Please Login or Register  to view this content.

Can anyone help please?

Thanks,

Louise

Try this:-
This works for the selection of any cell on the Sheet, although you could alter it to search on just column "A", for example.

Please Login or Register  to view this content.

Terrific, just what I was looking for.

Thank you,

Louise

You're welcome