software

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: www.excelforum.com/member.php...oamp;userid=29649
View this thread: www.excelforum.com/showthread...hreadid=493587nicholea

Formatgt;Condtional Formatting is the way to go.

Select the vendor due date cell(I'll call it C2) and CFgt;Formula 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 Formatgt;Patterns and OK your way out.Gord Dibben Excel MVP

On Wed, 14 Dec 2005 15:12:01 -0600, nicholea
gt; wrote:

gt;
gt;I have to keep a fairly basic database of accounts receivable invoices.
gt;I would like to set up the database so that when a vendor payment is
gt;due, the selection will automatically change color or highlight, or
gt;indicate in some way that the due date has been reached. Is this
gt;possible? Help!!!
gt;
gt;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(D1gt;0,D1lt;=TODAY()),quot;Payment Duequot;,quot;quot;)

another way would be to use Conditional
Formatting......Format/Conditional Formatting............just select
the quot;formula isquot; option from the drop down meny and this formula:
=D1lt;=TODAY()
choose your format....say red background and you're done!Hope this helps!
JG--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: www.excelforum.com/member.php...foamp;userid=6261
View this thread: www.excelforum.com/showthread...hreadid=493587