t0ny84
Board Regular
- Joined
- Jul 6, 2020
- Messages
- 205
- Office Version
- 365
- 2016
- 2013
- Platform
- Windows
- Mobile
- 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.
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
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