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