Recognising Conflicts

Hi,

Can anyone provide me with a formula or VBA for recognising conflicts in specific ranges?

I have attached an excerpt of the spreadsheet I'm working on now for recording annual leave, and I want to be able to have something flag up when two people from the same dept are on holiday. i.e. if both Smith and Davies are on holiday on the same day.

I hope this makes sense, apologies if not...it's the first time I've ever posted a on a Forum!!

Thanks

Staff Holidays - WIP.xlsx