SandraleeOster
3 years agoQrew Trainee
If statement for future and overdue dates
I want to color code based on due date.
Green = On Track (11 + days in future)
Yellow = Due Date is within 10 days
Red = Overdue is after the due date.
I was able to get my formula for green and red to work but my yellow is not working. If it is supposed to be yellow, it is actually turning green instead.
Any help would be greatly appreciated,
Thanks,
Sandy
------------------------------
Sandralee Oster
------------------------------
Green = On Track (11 + days in future)
Yellow = Due Date is within 10 days
Red = Overdue is after the due date.
I was able to get my formula for green and red to work but my yellow is not working. If it is supposed to be yellow, it is actually turning green instead.
Any help would be greatly appreciated,
Thanks,
Sandy
------------------------------
Sandralee Oster
------------------------------