Conditional formatting for difference between target date and today's date

Good morning all (sorry my first thread has to be probably a fairly straightforward request!)

I've been asked to create a database for our quality assessment schedule and doing so requires a 'countdown' effect for the target date of the next assessment. I'm using =TODAY() to give today's date in G2 at all times, and I want the target date boxes to be shaded:

• RED if the target date is within 30 days
• YELLOW if the target date is between 30-60 days
• GREEN if the target date is between 60-90 days (maximum possible range)

I have figured that I can only do "this month" or "next month" on the standard CF options, but I'm sure there must be a pretty simple code/formula for doing what I want to achieve. I've tried messing around with =DAYS and =IF but don't know enough about these formulae to get it right.

I've attached a dummy worksheet for help with reference.

Thanks in advance for any pointers!

Rob

Sorry TMS, not with you. Would this be through formula or code?

G2-90 won't be redundant, I haven't told the spreadsheet that the max range is 90 days as a colleague will be putting all the dates in manually.

Never mind - just realised a VERY boneheaded mistake that was probably causing me the same problem with everything I tried! Must revise the difference between < and > ...

For peace of mind, why couldn't I get =IF((D6-G2)>=60,format fill GREEN,format fill YELLOW) to work?

Thanks again for your help

All applied, working great. Thanks again - and don't mention it.