As an example these are set for report:-


RED = LESS than 30 Days from today

YELLOW = BETWEEN 30 & 90 Days from today

GREEN = GREATER then 90 from today