Highlight Alternate Duplicate Cells Based on Selection

Try this:-
NB:- this is based on selecting data in one specific column.

Please Login or Register  to view this content.

Regards Mick

Hi Mick,

Thanks for your reply - sorry if my post was unclear.

I am looking for a way to make the module work within a dragged selection range, rather than a specified row.

I am looking to change this part of the code to something like:

Set RngData = selection

But cannot quite work out how do to this with the count.

I've modified the code accordingly (see code) and change the Line:-

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

This will enable you to select a range instead of it being pre selected.
Regrds Mick

Perfect, Thank you!

I was almost there..!

You're welcome