conditional formatting not working

I'm trying to make my conditional formatting work so that a column is highlighted a specific color is the % Completed column is over a certain amount and the Due Date is in the next 7 days. I even moved this rule close to the top of the list, just to make sure this would work. Can anyone help me fix this?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!