[Solved] Conditional Formatting based on date and time

[HackerJL]

I have 4 columns:

A is expected time, b is expected date, c is actual time, d is actual date.

I want conditional formatting to highlight the item in C if its after A's time, but on B's date. Anything earlier is good as gold. But in this case an AND statement doesnt work, and neither does an OR. Can someone shed some light on this? I am pulling out my hair


thanks....a long time lurker of the forums.