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

You will need to post more information. Try uploading a version exactly the same as your current version, but with names replaced with mock names.
right now there is no department listed for each individual. Are everyone in this table from the same department?
Give a specific example of what you are looking for as well:
Ex. Smith and Davies are both on Holidays on Jan 13th (see 02 and 03). I want cell O1 to turn Red, or I want cell 07 to say "Conflict", etc....

You say you would like a column for conflicts, but I am not sure how that would work. I created a row for conflicts (row 19), with a formula returning a number of conflicts. Hopefully something like this is what you are looking for.