Conditional formatting for dates (in the future)...

Hi all,

I'm trying to do 3 rules in conditional formatting to do the following, I can't seem to get it right, can anyone advise on this:

I'm trying to find the formulas for:

Highlight cells that are equal to today's date and 3 months in the future (so let's say today & +90 days)

If over 90 days and a further 90 days again (so basically between 3 and 6 months in the future) then chance cells with those dates

If over 6 months in the future (say today & over 180 days) then all cells with these dates are changed to another colour


Thanks