Conditional Formatting With Two Conditions - HELP

[Bellablu]

Hi,

I am trying to write a formula that will pick up duplicate dates for each person in a really, really large worksheet.
I can identify the duplicate dates using the simple conditional formatting but have to select each group of data (the name) in order to da that, with 20 000+ lines of data this takes forever & sometime I might highlight to much data giving me an incorrect duplicates.

I have tried to attach an example of data that I am working but can not work out how, any assistance with that would also be good.
Any assistance would be very much appreciated.

Thank you in advance.

 

[sheetspread]

did you try a countifs formula?

 

[Joe4]

Hi, I am trying to write a formula that will pick up duplicate dates for each person in a really, really large worksheet.

Looks like an Excel question. Did you mean to post it in the Access forum?
If it was an accident, let me know and I can move the thread for you.