Conditions based on Today's Date

Hello,

I am currently using Microsoft Office 2007. I am trying to set up conditions for two columns that list dates. To summarize exactly what I want to happen:

If the date is before today (whenever I access the workbook), I want the cell to be highlighted red.

If the date is between now and next 30 days, I want the cell to be highlighted yellow.

If the date is between 31 and 60 days, I want the cell to be highlighted green.

If the date is greater than 61 days away, I want the cell to be highlighted blue.

I have been playing with excel alot trying to figure this out. If I had conditions for the above, I know how to change the formatting color. Knowing those conditions would also be useful for other military tracking I need to do and would have a high pay off. The equations are whats killing me. Any help would be greatly appreciated. Thanks!

Thanks, but where else can I reference for it? Its still giving me problems.