Good morning, I have a Vacation Tracker that I have been working on modifying and I have run into an issue. That issues is if an employee submits a request for vacation that falls within another request i would like to use conditional formatting it give me a visual cue to look at it further before approving.
Start date of Vacation would go in column "C" and end date in "D" shown below.
What I would like to be able to do is highlight the entry in Row 4 as it falls within the entry of row 3, the out come is shown below.
I have tried searching for an answer on google, but a lot of those solutions define the date range in else were and compare it to the date input. I guess this conditonal format needs to be slighlty more dynamic and that is sadly above my skill set.
Thanks in advance
Start date of Vacation would go in column "C" and end date in "D" shown below.
What I would like to be able to do is highlight the entry in Row 4 as it falls within the entry of row 3, the out come is shown below.
I have tried searching for an answer on google, but a lot of those solutions define the date range in else were and compare it to the date input. I guess this conditonal format needs to be slighlty more dynamic and that is sadly above my skill set.
Thanks in advance