Use conditional formatting.

To spell it out.

Let say B is the col you want formatted.
Put formula =Today() in $A$1
Select Entire col B.
Goto Menu - Format - Conditional Formatting
Choose
Cell Value is Less than $A$1

And presto....