Referencing conditional formatting in VBA

[strud]

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.

[taps]

Hi Strud,

This can be done in following way

Please Login or Register  to view this content.

Regards
taps

[strud]

Sorry for the delay taps (I've been off on holiday).

I couldn't get that bit of VBA to work properly.

Is there any chance you could expand on it a bit...?

Thanks in advance

Hi Strud,

This can be done in following way

Please Login or Register  to view this content.

Regards
taps