A different kind of duplicate data....

I have a spreadsheet that is aranged by duplicates in column B I'm trying to find rogue duplicates...
...I can't use the standard conditional formatting "highlight duplicates" option as there are supposed to be duplicates on the sheet but all duplicates are supposed to be grouped by rows...
and I can't filter as they need to be kept in date order, Column A

I need a Conditional Formatting Formula or VBA code that will highlight duplicates that have been seperated



sorry I'm as bad at explaing as i am at excel.... I've attached an example
Any help would be seriously apprecited.

Try this:-
There are 6 colours for discontinuous dups then they repeat.

Please Login or Register  to view this content.

Regards Mick