Until you have an actual workbook to work with, all that can be given is advice on hypothetical situations. It's rathe hard to code for that, especially when you're not clear on whether/why the cells need to be activated, change colour, etc.

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