Using bits and pieces of code I have picked up from lurking about on here I have managed to create a macro that colours cells that meet a certain criteria. Now I have hit a brick wall.

My problem

I want to list the rows, in Sheet "Raw Data", that contain a coloured cell. 3 lists, 1 for each coluor.

Red (3) appears only in Column D
Green (43) appears only in Column D
Yellow (6) appears only in column A

Ideally the lists will appear on sheet "Data"


Any suggestions would be great!