Worksheet Change Event - Multiple Cell Selection

Hi

I have the following code which changes the colour of columns M & N depending on the value in column L. It works fine when the user individually changes each row in column L but if they copy one row and paste it to multiple cells it doesn't.

Does anybody know how I might handle that?

Dion

Please Login or Register  to view this content.

Worked perfectly. Thanks Tom