Hi,

I need help with conditional formatting, I have tried
Highlight rules but am unable to get it to work.

I am trying to get an indication on which payment to chase.
for example if the contract is for 1 year starting 15/May/2017 to 14/May/2018,
payments fall due on every month starting 15th.

Once the cells are highlighted in say green color, I would want the color to change
to yellow after 3 days indicating the payment is past due, then the color to change
to red after 6 days indicating the payment is over due.

I think I may have to add a column for "paid", once it's paid there is no
need to highlight cells.

Sorry, my English is not so good....so if there is anything missing/unexplained
please message to me.

I have attached herewith a sample test file, hope it helps.



Thank you.

Attached Files

mn_alerts.xlsx (9.6 KB, 17 views)