Help with keeping track of payments

[Guest]

I am just createing a worksheet for a frien that keeps track of paymenst of
mini storage and anothre one for keeping track of rents collected. What I
would like to
do is in a cell that would be for the next month, after the 15th of the
month have something popup stating that this account is overdue. Any
suggestions. Thanks. Any suggestions as to a telplate for this is also
appreaciated.

 

[Guest]

hi,
how about using conditional formating to high light the
cell in ,say, red if date went past the 15th without a
corrosponding entry in another cell?