Further to my earlier post about conditional formatting. I now need to change it slightly and use a different field, but also to have 3 colours instead. I will see if I can explain it. 

I have butchered a copy of the Purchase Orders and Returns report as its got 90% of the information that I need from it. I have added RequestedDeliveryDates.DeliveryDate to the Details section that is shows the requested delivery date on each line item per PO and I have set the style to display as red by default and have used 

IF RequestedDeliveryDates.DeliveryDate > REPORT.DATE THEN

BEGIN
TextStyle -> Color := NamedColor("Green");
END

As conditional formatting and this works perfectly, red if its late and green if its not.. 

BUT

I need to add an extra step where the RequestedDeliveryDates.DeliveryDate is amber (or orange) if the date is within the lead time of the item. I am pretty sure I need to add the supplier table to the report using a join so that I can get the lead time or whether I can just reference that table. 

As far I can understand the logic its RED if the date is late, Amber if the date is late but within the lead time and green if its not late. 

Hope that makes sense.