Create list of rows with coloured cell (excel2003)

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!

I'm not a VBA expert, but a quick rummage through the help facilities produced:
Range.Interior.ColorIndex
Put a couple of loops round this and you should be able to get the result you are after.

Thanks for that.

I did find the same when i was doing my own search but I didn't know what Loops where so I couldn't get it to do what I needed.

I had a play with Loops and got it to work!


Ta Muchos