Can't help you with macros, but you could use Conditional Formatting to highlihgt it. This is what I did.
highlight the column you want to use. Go to conditional formatting. Click New rule. Click format only cells that contain. In the dropdown, choose less than or equal to. In the next box, put TODAY(). That will highlight all cells that are less than today.