Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Mike Busch
 
Posts: n/a
Default Help with keeping track of payments

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   Report Post  
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
HELP!!! EXCEL TRACK CHANGES CONUNDRUM! working girl Excel Discussion (Misc queries) 2 February 21st 05 08:30 PM
Reports on the plan of consolidated payments in EXCEL Sverchok Excel Discussion (Misc queries) 0 February 13th 05 06:11 PM
Teplate to Track sales of multiple products on per client basis. Agriculture Excel Discussion (Misc queries) 2 January 29th 05 10:57 PM
Track Changes: Making "All" the default Bettergains Excel Discussion (Misc queries) 0 January 11th 05 09:35 PM
How to calculate total interest on 12 month loan with early payments Fred Smith Excel Worksheet Functions 0 January 6th 05 02:33 AM


All times are GMT +1. The time now is 07:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"