Hi all,

I need to learn some more advanced Excel techniques.

To start with, I am wondering if this is possible:

I have highlighted various cells a particular colour in an excel worksheet.

Is it possible to automatically copy all the coloured cells and paste them together either on the same worksheet or another? So if I changed the colour of a cell it would automatically be added to a list elsewhere.

I am also open to other suggestions for achieving the same effect.

Cheers.