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

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

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