Conditional Formatting for Date and Time in separate cells

[LibbyMcD]

I would like to use conditional formatting to highlight cells that have an actual date and time after the originally scheduled date and time.

For example, column 4 row 3, the delivery time is 18 minutes late - I'd like to highlight that. And in row 4, it's a day late, that would also need to be highlighted.

I'm having trouble finding anything online that would help with this since it's not just date, and not just time, and they are in separate columns. Any help would be much much much appreciated!

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Sched Date[/TD]
[TD]Sched Time[/TD]
[TD]Actual Date[/TD]
[TD]Actual Time[/TD]
[/TR]
[TR]
[TD]7/25/18[/TD]
[TD]1:00 pm[/TD]
[TD]7/25/18[/TD]
[TD]12:55 pm[/TD]
[/TR]
[TR]
[TD]7/25/18[/TD]
[TD]1:00 pm[/TD]
[TD]7/25/18[/TD]
[TD]1:18 pm[/TD]
[/TR]
[TR]
[TD]7/24/18[/TD]
[TD]10:30 am[/TD]
[TD]7/25/18[/TD]
[TD]9:00 am[/TD]
[/TR]
[TR]
[TD]7/24/18[/TD]
[TD]1:00 pm[/TD]
[TD]7/24/18[/TD]
[TD]11:53 am[/TD]
[/TR]
</tbody>[/TABLE]

 

[Joe4]

Welcome to the Board!

Let's say that you grid above is in the range A1:D5.
Then select cells C2:D2, and enter this Conditional Formatting formula:

=or($C2>$A2,and($A2=$C2,$D2>$B2))

and then choose your highlighting color option.

I think this should do what you want.