Description: I have a dropdown for "Attendence", which has values like "Present-P", "Absent-A","Half day-H","Sunday-S","Holiday-H" etc and another cell called "Hours" to fill in the o of hours worked. Condition is set in data validation of Attendence column such that if hours=0, only "Absent-A","Sunday-S","Holiday-H" will be displayed. Else, others will be displayed.

Automation: By default, Attendence=A and hours=0. So user has to modify hours, in order to get other values like present, half day etc in attendence column. Now he can enter present and then go change hours to 0. The system accepts.
So i tried a Worksheet_Change(ByVal Target As Range) sub to avoid this. Not sure how to go about the validation.
Anything bright on this?