My company records some information as seen below to track services on our products.
The first date (D) is the date we receive the part and it needs to be delivery back to the customer within 14 working day and recorded in E, the second date.
So. I would like to do the following. From the date recorded in D to todays date.....
Between 1-10 days have D filled as green.
Between 11-14 days have D filled as Yellow
Above 14 days have D filled as red.
However if C, which now has "Received", has "Complete" written the entire row is coloured Green regardless of date.
Can someone help? I was hoping it was simple to people more competent than me and it would be great if it could all be done in one formula?
|RTM||2537||Received||01/08/2019||08/08/2019||Received from Amey Rail||EST - 647||65953751139||RTM211092537||7729876878||Updated||HAYS||User: Carillion||Robert Gray||7806 975 533|