I have found loads of posts about conditional formatting cells using VBA but I would like some info on whether it is possible, and if so how, to use conditionally formatted cells as a reference in VBA.

So for e.g. whether you could use a macro to copy only cells that have been formatted red?

Is this possible and if so how would I go about it?

Thanks in advance.