Conditional fomatting: Date turns red if less than 3 months remains

[jaywizz]

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.

[jaywizz]

Solved.

After playing around with the cells I have found a rather clunky way to deliver this.
Cell A1 =Today()
Cell A2 =A1+45 - This gives me roughly 6 weeks ahead of the given date
Cell A3 =A1+90 - This gives me roughly 3 months

I then select the cell that I have my deadline date in. And pick the conditional formatting option to highlight the cell orange if the deadline falls Between A2 and A3 then highlight in red if the deadline is less than cell A2.

To keep things clean I then hid the A column

[Coleman34]

If you highlight the cells with the dates in them, you can use Conditional Formatting>Highlight Cells Rules>Between... this allowed me to choose dates, but instead of dates, insert the formula =Today()+91 in the first box and =Today()+180 in the second box. Then, with the dates cells still highlighted, use Conditional Formatting>Highlight Cells Rules>Less Than... and enter the formula =Today()+90.
Hope that helps.