I have three columns, 1st = title of project. 2nd = project due date. 3rd = expected completion date. I need to use conditional formatting to color the title for each project either green (if expected completion date is 30 or more BUSINESS days before due date), yellow (if expected date is between 30 and 15 business days before due date), or red (if expected date is 15 or less business days before due date).
Solved by T. Q. in 13 mins