The macro relies on the colours, because that is what you have provided as your example.

I don't know how you expect someone to provide a solution when the examples you provide aren't real. First you tell me the solution doesn't work because you forgot to mention that there are differences between the data in the data sheet and the report sheet. Now you tell me the solution doesn't work because the colours in your example sheet don't exist in the 'real' one.

I'm not going to waste any more time on this trying to provide solutions based on dodgy examples.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]