Folks, quick qustion on conditional formatting (Excel 2010)

I want to show deadline dates less than 3 months from today as being red
Between 3 and 6 months as being amber

I have created a cell with =Today() to act as the date to compaire against the deadline date.