Excel 2007 : Changing row colour if column D date is before current system date

Have a 'competitions entered' spreadsheet which contains a closing date for each competition in column D. I'd like a formula or macro which compares each date in column D and if the date is earlier than todays date format fill the background of that row to a grey colour.

Would be grateful for any suggestions to achieve the above please.