Conditional Formatting With Multiple Checks

t0ny84

Board Regular
Joined
Jul 6, 2020
Messages
134
Office Version
  1. 365
  2. 2016
  3. 2013
Platform
  1. Windows
  2. Mobile
  3. Web
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.

1605011579141.png


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
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

etaf

Well-known Member
Joined
Oct 24, 2012
Messages
4,587
Office Version
  1. 365
Platform
  1. MacOS
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
ABCD
1TeamWeekMeeting DateMeeting time
2A1/1/209:00
3A1/1/209:00
4A1/3/2010:00
5A1/4/2012:00
6B1/1/209:00
7B1/6/2012:30
8B1/7/2010:00
9C1/8/201:00
10B1/6/2012:30
Sheet1
Cells with Conditional Formatting
CellConditionCell FormatStop If True
A:DExpression=COUNTIFS($A:$A,$A1,$C:$C,$C1,$D:$D,$D1)>1textNO
 
Solution

t0ny84

Board Regular
Joined
Jul 6, 2020
Messages
134
Office Version
  1. 365
  2. 2016
  3. 2013
Platform
  1. Windows
  2. Mobile
  3. Web
Thanks so much etaf I was missing the >1
 

etaf

Well-known Member
Joined
Oct 24, 2012
Messages
4,587
Office Version
  1. 365
Platform
  1. MacOS
you are welcome
 

Watch MrExcel Video

Forum statistics

Threads
1,127,502
Messages
5,625,179
Members
416,076
Latest member
ralitsab

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top