Perhaps 
=LOOKUP(A1-TODAY(),{0,10,25},{"yellow","red","green"})
where A1 holds the assessment date ?