Worksheet_change event add / remove validation

In the attached, if a user puts a number in the columns 'Sick', or 'Susp'd / Leaver', validation dropdown lists are added to the corresponding cell in the 'Comments' column.

If entries are deleted, the validation is also deleted from the relevant comments column (usually).

This works to a point, but if you enter a value without hitting enter (e.g. Press tab or a cursor other than down, or click on a different cell), the validation does not get applied.

Also, if you delete entries one at a time from the bottom of several consecutive ones, the delete validation does not work.

The problems arise when testing whether the Target is blank - it will be in a different position depending on how the data has been entered.

Thanks in advance for any help you can offer - it will be greatly appreciated.