Select cells by Background colour

Hi,

I would like the contents of all cells in a Colum that have a red background copied and pasted in a single cell as below :-

1,34,54,78,99,345,78

All the numbers above would have had a red background colour, all the other cells are ignored,

Hope someone can help,

Cheers

WCE

Hi,

the cells are using Conditional formatting to change the colour background is this what you mean ?

Cheers