Hello,
I am wondering if it is possible to have a warning pop up box to appear when the workbook is opened if one of my customers is over 15 days past due date?
For further clarification:
The company usually works on payment terms of "60 days from the end of the month of delivery"
My workbook has multiple customers tabs, in each tab has the Invoice number, Sale Date, Due Date and running (accumulative) total. When a customer pays I add in a different column; the amount they paid and the payment date which will then deduct this amount from the running total.
What I would like is some way for the workbook to warn me or to somehow bring to my attention (error message pop up) if one of my customers has not paid by 15 days past their due date (therefore very late) - is this even possible in excel?
I have found that conditional formatting does not get the required result and in such a big workbook seems to slow it down considerably.
Any help would be greatly appreciated
Bookmarks