LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
nicholea
 
Posts: n/a
Default Automatically Indicating Payments Due


I need to keep a fairly basic accounts receivable database and would
like to know if there is a way for excel to automatically indicate when
payments are due. I need to set it up so that I can enter when the
invoice was sent and also when it is due. When the due date has
arrived, I would like for excel to highlight the vendor that is due or
change the color of the selection AUTOMATICALLY. Please let me know if
this is possible and how it can be done!

Thanks!


--
nicholea
------------------------------------------------------------------------
nicholea's Profile: http://www.excelforum.com/member.php...o&userid=29649
View this thread: http://www.excelforum.com/showthread...hreadid=493790

 
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
Automatically update cells Maddoktor Excel Discussion (Misc queries) 1 December 8th 05 12:56 AM
display multiple lines of text within a merged cell automatically sssizemore Excel Worksheet Functions 1 June 15th 05 02:30 AM
How do I forecast future payments by analyzing past payments? CeeBee Excel Worksheet Functions 1 March 17th 05 06:43 PM
Automatically Populating Worksheet from Collected Input for Pricelist David Littrell via OfficeKB.com Excel Worksheet Functions 1 January 6th 05 05:04 PM
Automatically Populating Worksheet from Collected Input for Pricelist David Littrell via OfficeKB.com Excel Worksheet Functions 0 January 6th 05 04:29 PM


All times are GMT +1. The time now is 04:08 PM.

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

About Us

"It's about Microsoft Excel"