If you want red only on the day that it becomes equal to today's date, then choose:

Cell Value is >> equal to >> =TODAY() (this is so blank doesn't get highlighted).

or if you want to colour red if in the past.

Cell Value is >> is between >> 1 and >> =TODAY()