Conditonal formatting if day after and before certain time

[Halidat]

Good afternoon,

I am looking to highlight the cell in red whenever:

• C2 date is at least one day after B2

and if

• C2 time is before A2 time

[6StringJazzer]

Select the entire column C (including header row)

Create a conditional formatting rule with this formula:

=AND(INT(C1)>=INT(B1+1),MOD(C1,1)<A1)

[Halidat]

Thank you it works perfectly!

[6StringJazzer]

You're welcome and thanks for the rep!