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