Conditional Formatting - HELP

Rachele-

I have added two conditional formatting formulas to your worksheet that highlight overdue red and within 5 days yellow.

The formulas are based on the values in Column I and are applied to this range:

=$B$6:$BJ$32

Remember that conditional formatting rules are applied in the order shown in the Conditional Formatting  Rules Manger

Overdue:

=$I6<$C$2

Within 5 Days:

=AND($I6<($C$2+5),$I6>$C$2)

Here are a few additional resources:

https://exceljet.net/blog/test-conditional-formatting-with-dummy-formulas

 http://www.quickbooks-training.net/excel-tutorial-conditional-formatting-to-indicate-upcoming-or-overdue-payments/

Hope this helps solve your issue!