Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
#2
![]() |
|||
|
|||
![]()
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? -----Original Message----- 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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
HELP!!! EXCEL TRACK CHANGES CONUNDRUM! | Excel Discussion (Misc queries) | |||
Reports on the plan of consolidated payments in EXCEL | Excel Discussion (Misc queries) | |||
Teplate to Track sales of multiple products on per client basis. | Excel Discussion (Misc queries) | |||
Track Changes: Making "All" the default | Excel Discussion (Misc queries) | |||
How to calculate total interest on 12 month loan with early payments | Excel Worksheet Functions |