Conditional Formatting with Dates:overlap

I do not think what I am asking is that unique but I cannot seem to find the right set up that works just like this already listed in the forums. Basically, I am using Excel 2007 and I have a sheet that shows the due dates for upcoming projects. Let's say the dates range from 2 weeks ago to a few months in the future. I want the dates that are today or before to be red (showing overdues), the dates within the next 14 days to be yellow (need attention), and any dates over 14 days in the future to be green. How do I use conditional formatting to achieve this? I tried several different ways but it seems like the overlap makes everything green or everything red. I am familiar with the basic idea of conditional formatting.

You nailed it! Thanks for the quick response! That is exactly what I was looking for. It appears that the order of the rules is what was throwing me off. Much appreciated...the boss will be pleased!