Copy text of cell into another tab based on its color

[imdmeyer]

Hi,

I want to create a table in a second tab (2nd figure), where all the experiment numbers which have a certain color (1st figure), line up into a column. In this way, all the different types of experiments are The color of the experiment ID (column B) is determined by the text in column E (here: test). 

Any help would be greatly appreciated.

[#2]

Since you've created a spreadsheet (presumably) in order to create those images, would it be possible to actually post the spreadsheet? That way some of us could use it (rather than creating our own secondary version) to demonstrate various methods.