troubleshooting Question

Highlight Cell if Match

Avatar of Billa7
Billa7 asked on
Microsoft Excel
8 Comments1 Solution969 ViewsLast Modified:
I need Experts help create a conditional formula to highlight cell at Column D in red if the following condition comply:

If the cell in Column D has been:

- Sharing the same date (Column C) and
- Time overlap (Column D)

e.g. Cell G3 has same data with G4 (Same Date), however the timing at Column D have been clashed, therefore cell G3 need to highlighted in red.   Attached the workbook.
CrossCheck.xls
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros