Hello

I have list of dates in column I of a spreadsheet, This indicates a date when their account is due for a review. What I want to do is set a formula to colour code them accordingly, The forumula needs to look at the date in column a which is in the format DD/MM/YYYY and based on todays date tell me the following:

Turn the cell red if the date is overdue
Turn the cell Amber is is due in 3 months or less
Turn the cell green if its due on 3 months time or more.

Can anyone help me with this, ive tried a few different things but the colours are not changing to what I am expecting it to.

Also Im guessing that each time I opene the spreadsheet it re-applies the conditional formatting or is it something I need to re-apply each time I want to check.

Thanks in advance