Excel 2007 : Date related Conditional Formatting

Greetings,

I wonder if one of you out there can help with my problem.

I need to create a database to store driver's licence details. I need to have the expiry date flag up if it has expired so it flags up as in example2.

In example1, cell A!, i have used the TODAY() formula to set the date and conditionally formatted column c to flag up if the date is less than today, but that now flags up everything that is not greater than cell a1.

Ideally, i would like the entire row to flag up if the date has expired.

Any help would be greatly appreciated

Scott