Need help with conditional formatting
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.
|