Help with formula for conditional formatting to highlight if date and time are the same

[rv02]

Dear All

I have a spreadsheet with a list of events, date and time of the events.

What I need to do is set up conditional formatting so that any even with the same date and time will be highlighted.

I have included a sample spreadsheet for your reference. In the attached spreadsheet I need to highlights events D and E and events A & C as they have the same date and same starting time. In my actual spreadsheet if have a list of over 10000 events and I was wondering whether conditional formatting with formula would achieve this? or is there a better way f doing this.

Any help is appreciated it

[davsth]

IT depends what you want

If you want every duplicate value formatting that is easy its just a countifs function matching all dates and times in the range and If they are greater than 1 its a duplicate.

the problem comes if you want each set of duplicates shaded the different colours, this would need a vba approach

[rv02]

Dear davsth
No i just need the duplicat cells to be shaded with the same colour. Only thing is I do not know the formula and if you can show me the the sheet I attached I would really appreciate it

[davsth]

Conditional formatting, new rule, use a formula to determine which cells to format
=COUNTIFS($B$2:$B$7,$B2,$C$2:$C$7,$C2)>1 colour as you wish

[rv02]

thahis worked great thank ou very much for your help