Colour change by date

[Guest]

I have searched for an answer to this but haven't managed to nail it:
I wish to colour cells containing future dates within 30 days of TODAY() red.
This bit is straightforward, but I wish to ignore all dates which have
passed (ie yesterday and beyond)
How can I modify the CF line =D7-TODAY()<30 to do this? Or would code be
better?
Ideally, I'd like something like
Between 0 and 30 days = red, 31 - 60 days amber, 61 - 90 days = green.

Thanks in advance

 

[Guest]

You need to add an and

=and(D7-TODAY()<30, D7-TODAY() >0)

 

[Guest]

Nice and simple
Thanks Joel