Conditional Formatting in relation to date

Hello,

I'm setting up a Warrenty management system and want to colour code parts that are still covered by the warrenty and parts that the warrenty has expired for.

Therefore, I'm trying to find a formula and instructions for shading date values in a column on a worksheet based on the warrenty expiry date (listed down one column) relative to today's date.

For example a cell that shows the warrenty expiring date 27/07/2010 when the current date is 01/01/2008 would be shaded green, and a cell that shows the date 01/01/01 when the current date is 05/07/02 would be shaded Red.

Thanks in Advance for your help.

<config>Windows XP / Excel 2007