Hi,

The code I wrote below works fine, I have also defined some cells as "ColourRange" in the same worksheet, so how do I make the code only works for ColourRange's cell rather then entire worksheet?

Thank you in advance.

Ed

HTML Code: