Produce error message when pasted values break validation rules

I have a (simplified example) matrix consisting of inputs and alarms. Each action (X) should have an input and an alarm i.e. no actions should be inserted in column E or row 6.

Capture.PNG

I used data validation to implement this and it works.

Capture2.PNG

However if I paste data to these cells they do not follow the validation rules. I inserted this VBA code to prevent this (extracted from www.j-walk.com/ss/excel/tips/tip98.htm):

Please Login or Register  to view this content.

However, this code also prevents values from being pasted into cells even when they do not break validation rules e.g. if I paste an X to input a;alarm 1, I get an error message. Is there any way to make the make the user aware if data he/she has pasted has broken data validation rules. This can be through error/warning message or highlighting of invalid cells, whichever is possible.

Thanks for the reply.

Yes I had ValidationRange set to D4:H8. In line with your comments I have altered the code to this:

Please Login or Register  to view this content.

This now circles all cells that have no input or alarm. But I only want cells that have an action and no input or alarm to be circled.
To do this I know I must change the formula "=AND(NOT(ISBLANK($C4)),NOT(ISBLANK(D$3)))" but I am struggling with this. I am trying something like "=AND(ISBLANK,NOT(ISBLANK($C4)),NOT(ISBLANK(D$3)))" but this is giving an error. The answer should be pretty obvious but I can't figure it out!

Okay I found the formula that works:

"=OR(ISBLANK(D4),AND(NOT(ISBLANK($C4)),NOT(ISBLANK(D$3))))"

now I just need a line of code that produces an error/message box notifying the user why a cell has been circled.

e.g. If CircleInvalid=True
MsgBox "Cell circled because..."

Any ideas?

Okay I figured it out. Code is:

Please Login or Register  to view this content.

Thanks for your help