Conditional Formatting Issue when using date [SOLVED]

[SandyMarie321]

I am using a WB with a Calendar pop up when a cell is selected.

D2 is the titled Due Date Field (date shown after clicking date in calendar pop up)
E2 is my Task Name.

I have tried to set conditional formatting a few ways to get this result: Highlight E2 if D2 is past. (highlight task if late)

I have tried formatting based on formula using the following:
D2<TODAY() -- made it hightlight cell yellow
D2=TODAY() -- made it normal
D2>TODAY() -- made it normal

Using an IF field from another cell which I added. I did an IF(D2<"TODAY()",Overdue,Current) then based the formatting on Overdue or Current. But that IF formula had the same problem and wouldn't update.. I assume it would have to be from the macro using the calendar.

It works for the initial option. Then when another date is selected it doesn't update.

I don't have the error when It is a NORMAL Date field.

Any ideas.. I am going nuts.