Hi all,
I'm creating a project management file for a team of developers who work in the fashion industry.
Capture.PNG
The ETA is entered when the developer enters a date when they expect their labdip to return from a supplier.
There is currently a conditional format in for the following:
Capture1.PNG
My question:
I also need a conditional format in for the ETA (c.S) and Date Received (c.T) columns so that...
1. If the labdip is received before the ETA, both fields go green.
2. If the labdip is received after the ETA, both fields go yellow.
For context - if the labdip is received in time and the box goes green (like all other boxes), then the whole project is on time. I need the field to go yellow so that when it comes down to the end point and the supplier wants to ask for a 2 weeks delay in shipping the goods, it is visibly clear to the developer that the supplier was late in sending the labdip (or whatever it is!) and has a right to claim a discount etc.
I know how to add a conditional format in for the following columns so that when something is rejected it goes red and the adjacent comment box also goes red. But I can't seem to figure how to merge these two formulas!
Capture2.PNG
Hope this is clear
Thanks in advance!!
Bookmarks