Conditional Formatting With Multiple Checks

[t0ny84]

Hi All,

I am wondering if someone might be able to point me in the right direction\best way to do the following:

Using below screen snip:
For everyone in the same team check to make sure no one has the same Meeting Date and Time or Meeting Date2 and Time2.
If different teams then the conditional formatting won't apply.

I am thinking Conditional Formatting would be the best option but cannot figure out the formula to use, happy to use VBA if more suitable.

As always,
Thanks in Advance!
t0ny84

 

[etaf]

you can use a countifs()
this is just testing the 1st set of dates
BUT the times need to be exact
I suspect if a meeting is at 9:00 and another in the team at 9:15 - then this should also flag
which then means whats the overlap?

Book1
	A	B	C	D
1	Team	Week	Meeting Date	Meeting time
2	A		1/1/20	9:00
3	A		1/1/20	9:00
4	A		1/3/20	10:00
5	A		1/4/20	12:00
6	B		1/1/20	9:00
7	B		1/6/20	12:30
8	B		1/7/20	10:00
9	C		1/8/20	1:00
10	B		1/6/20	12:30
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A:D	Expression	=COUNTIFS($A:$A,$A1,$C:$C,$C1,$D:$D,$D1)>1	text	NO

 

[t0ny84]

Thanks so much etaf I was missing the >1

 

[etaf]

you are welcome