Conditional format within a loop

[Catherine Anne Gibson]

I am trying to add conditional formats within a loop. I can get this to work for a range and copy down but not elegant!

How do I do this for cell offset.

PS only my fist week in VB so any help welcomed

KG

 

[GlennUK]

Can you explain why you can't add them all in one go? ( i.e. explain exactly what you mean by "I can get this to work for a range and copy down"? )

 

[Catherine Anne Gibson]

CAme back to work and my colleague has solved the problem bu offsetting the format