Sort/select by duplicates containing cell colour

[JamesTheNoob]

I need COLUMN A to sort all duplicates to the top IF one of the duplicates contain a cell with a specific colour.

Example:

[TABLE="width: 500"]
<tbody>[TR]
[TD]234632498523[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2523242237[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8834523526[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]777777777777[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]24454784568[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]33333333333 CELL COLOR: YELLOW[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]573423452345[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]777777777777 CELL COLOR: YELLOW[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]33333333333[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]234573356[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]



Wanted outcome:

[TABLE="width: 500"]
<tbody>[TR]
[TD]777777777777 CELL COLOR: YELLOW[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]777777777777[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]33333333333 CELL COLOR: YELLOW[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]33333333333[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]353757353453[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]573423452345[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3454756883453[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]57568567563[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]234573356[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Or simply just selecting the duplicate pairs with cell colour as I need to move them to their own spreadsheet.
My issue is that I need to do this with 57.000 rows, so I would need this process to be automatic and apply to all duplicates with the specific cell color.

Any help guys? I have Kutools if this is any good.

Regards,

James

 

[Panda514]

Hello, are there ever cell color yellow's if it isn't a duplicate? If all the cell color yellow's are duplicates then you can just filter by color and you will see only the rows that are colored yellow. If you will have more than 1 duplicate, for example two colored cells with 1234 in it and one not colored cell with 1234 in it, then you should do one more step. You could follow the same process as above and copy/paste that group to a new tab then remove duplicates.