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: copy to clipboard
=D8>A5+90

AMBER
Formula: copy to clipboard
=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