Difference Between Two Dates/Times In Two Cells

The attached shows a DEADLINE Date/Time in Column D. The current Date/Time is displayed in Column E and is counting down to the Date/Time in Column D.

What I've tried to accomplish with a formula is a notification in Column F, when D & E equal one another (the count down has reach the end).

Ultimately, I'd like to call a macro that will display a Userform and for the corresponding row of F to be highlighted with a color.

I've tried using various formula formats " =IF(D1=E1,"Message","") ", =TIMEVALUE and =DATEVALUE. I've done alot of searching on the net ... haven't found anything that helps.

If this can be accomplished with a formula or a macro or both ... would be great.

Your assistance is greatly appreciated ! Thank you.

Both.

I had both columns formatted the same but the dates were being displayed differently.

The countdown timer continues running past the "zero" time. I'll scratch my head some more on this one. I'm agreeable to modifying the entire setup if you have any ideas ... just so long as the result is the same.

(See ... I'm not picky )

***** Bump ******

Glenn:

Thank you ... the formula runs great, stopping the count down when it matches the target date/time.

I've tried using the following in F2 to fire off a visual notice that I can work with but its not doing what I expected:

Please Login or Register  to view this content.

I've also tried

Please Login or Register  to view this content.

and a few other variations ... no good. Maybe I need to do something with VBA for this portion ?

Any suggestions for this ?

Sorry .... I didn't think to look if Conditional Formatting had been applied. Now I see what you did. On my end the cell does not turn Red when it reaches 0.

See attached. Did I do something wrong ?

Hey Glenn ...

I did conditional formatting on F2 and the coloring of cell works like a charm. Previously, the conditional formatting was in E2 and that was not firing.

Thanks ... got it figured out now.

Cheers !