2 Conditional formats but only 1 working

Hi

I have 2 conditional formats but only one of them is working, I know why, but I don't know how to change it.

A8 needs to change to AMBER if its 60 days overdue, RED for 90, But it'll constantly stay on AMBER. So I think I need to change it to go amber between days 60-89 then Red for 90+

These are the 2 formats I have:

RED

Formula:

=D8>A5+90

AMBER

Formula:

=D8>A5+60

Ideally I would like it as:
NO VALUE or 90+ to be RED
60-89 AMBER
1-59 GREEN


How do I change the formulas for this please?

Thanks

I've completely thought his out back to front!!!!! haha

Attachment below.

In A8 Is the material audited.
A5 is todays date (in the attachment ive manually put dates to test.
D8 is the most recent date between a set range.

A8 will flag red if A5 is +90 days of D8
A8 will flag amber if A5 is between 60-89 days of D8
A8 is Green if A5 is less than 60 days of D8

Ideally, if There is no date in D8 then A8 will flag red.
I think i'm there now, but would like someone to check it over if possible.

Thanks

MaterialsAudit.xls

Thanks.

D8 Needs to be

Formula:

=MAX(F8:BE8)

Because a date will be entered along this range when an audit is done, and D8 will return the most recent audited date.
So then if an audit is x amount of days behind then that's when the effect takes place.

sorry, I was changing the wrong day and got muddled up again!! Haha

Works a treat.

Thanks very much!!!!

Actually, ten Amber isn't working?

It's either Red or Green

Would I need to dictate a range for the amber? >60 <90

Thanks

This seems to be working now for Amber:

Formula:

=AND(D9<TODAY()-59,D9<TODAY()-1)