Conditional Formatting - Date dependancy

Hi everyone,

I am trying to set up some conditional formatting to do the following...

I want to enter dates into a column for work, the date will represent the due date the work is to be completed. I would like the cells to change colour depending on how close to the deadline it is.
i.e. Job needs to be completed by 01/12/07, so I put this date in my spreadsheet in the Due Date Column, I need the conditional formatting to change from Green (being OK) to Orange (meaning Deadline is X amount of days away and Red (Meaning there is 24hrs or so to go)

I hope this makes sense.

your help is appreciated

Cheers

i did it like this:

=$A$1>=TODAY()-1

formatted as red

=$A$1>=TODAY()-7

formatted as orange

=$A$1>TODAY()-21

formatted as green