I'm trying to create conditional formatting that will do the following:
A3= today's date
I10: The due date
Anything due before today's date= Red
Anything due within 5 business days of A3= Yellow
Anything due beyond 5 business days of A3= Green
I've created the following conditional formatting rules: =IF($A$3>WORKDAY(I10,2,$M$5:$M$6),TRUE,FALSE) [will be red] =IF($A$3>=WORKDAY(I10,2,$M$5:$M$7),TRUE,FALSE) [will be yellow] =IF($A$3<=WORKDAY(I10,6,$M$5:$M$6),TRUE,FALSE) [will be green]
I also need a way to count the amount of reds, yellows, and greens, without using a macro. I have used this formula, but it's not working properly: =IF(J10="","",IF(J10="Complete",4,IF(J10<$A$3,1,IF(J10=$A$3+(WORKDAY(I10,6,$M$5:$M$6)),3))))) Upon receipt, I will give the file.
None of my formulas are working. Any help?
Bookmarks