I have a drop down list of 5 options to track case status in cell E1 of sheet 5 (active, paused, waiting, closed, declined). On sheet 6, cell F1, staff are asked to enter a closure date. I am sure they will forget to go back and change their case status selection to 'closed' so I would like E1 to override whatever the current selection is and enter 'closed' as soon as a date is entered in F1, sheet 6 but I am struggling to make this work with the data validation still turned on - any ideas?