Indicating Payment Due
I have to keep a fairly basic database of accounts receivable invoices. I would like to set up the database so that when a vendor payment is due, the selection will automatically change color or highlight, or indicate in some way that the due date has been reached. Is this possible? Help!!! Thanks -- nicholea ------------------------------------------------------------------------ nicholea's Profile: http://www.excelforum.com/member.php...o&userid=29649 View this thread: http://www.excelforum.com/showthread...hreadid=493587 |
Indicating Payment Due
nicholea
FormatCondtional Formatting is the way to go. Select the vendor due date cell(I'll call it C2) and CFFormula is: =$C2=TODAY() + 2 The +2 gives two days notice that due date is coming soon. You can delete that if you want no notice. Note the $ sign to anchor the formula to Column C for copying down. Pick a color from the FormatPatterns and OK your way out. Gord Dibben Excel MVP On Wed, 14 Dec 2005 15:12:01 -0600, nicholea wrote: I have to keep a fairly basic database of accounts receivable invoices. I would like to set up the database so that when a vendor payment is due, the selection will automatically change color or highlight, or indicate in some way that the due date has been reached. Is this possible? Help!!! Thanks |
Indicating Payment Due
Hi, Here's one way: say that your due date is in column D, you could put this formula in a blank column: =IF(AND(D10,D1<=TODAY()),"Payment Due","") another way would be to use Conditional Formatting......Format/Conditional Formatting............just select the "formula is" option from the drop down meny and this formula: =D1<=TODAY() choose your format....say red background and you're done! Hope this helps! JG -- pinmaster ------------------------------------------------------------------------ pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261 View this thread: http://www.excelforum.com/showthread...hreadid=493587 |
All times are GMT +1. The time now is 03:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com