I have a spreadsheet which has a column of dates, I would like to compare the dates with todays date to change the background colour of a cell to be either green, yellow or red, so that I can quickly look down the column to identify rows that require action.. i.e.

If the date in the column is more than a week ahead no action is required and the cell would show green.

If the date in the column is between 1 and 7 days ahead action is required and the cell would be yellow.

If the date in the column has passed action is overdue and the cell would be red.

Thanks
Pete