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:

234632498523
2523242237
8834523526
777777777777
24454784568
33333333333 CELL COLOR: YELLOW
573423452345
777777777777 CELL COLOR: YELLOW
33333333333
234573356

<tbody>
</tbody>

Wanted outcome:

777777777777 CELL COLOR: YELLOW
777777777777
33333333333 CELL COLOR: YELLOW
33333333333
353757353453
573423452345
3454756883453
57568567563
234573356

<tbody>
</tbody>

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.