Conditional Formatting with three criteria

[john3j]

I am trying to apply conditional formatting to column B, which contains dates. If the date is outside if 6 months, the cell should be green. If its within 6 months, it should be yellow. If the date is within three months, it should be red. I am using Microsoft Office 2010. Any help would be appreciated!

[SamT]

How critical that the date is exactly in month intervals? If not very critical:

Condition 1 <= NOW()+90
Condition 2 <=NOW()+180
Condition 3 >Now()+180

:dunno Maybe the condition numbers should be reversed.

[john3j]

That worked great! I just had to reverse the order! Thank you very much for your help.