Copy Colored Cells

I need help with the following:
I have a column with different colored cells and I need a formula to copy this column in another workbook but I only want to copy the last 6 cells of each color. Maybe the attached example will help you(numbers in cells are random)

page0001.jpg