I am trying to color code a worksheet for project status based on % complete and Due date.
My logic
If Due date is less than 7 days from today and % complete is less than 75 highlight red
If Due Date is less than 14 days from today and % complete is less than 50 highlight yellow
Else highlight green.
Here are the rules I used in conditional formatting:
The first rule works however it never executes the second rule (even if I switch them).
=IF(and($F$9<Today()-7, %G%9<75%)
=IF(and($F%9<Today()-14, %G%9<50%)
I haven't gotten to Else highlight green.
Your help & expertise is greatly appreciated.
Bookmarks