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

Format>Condtional Formatting is the way to go.

Select the vendor due date cell(I'll call it C2) and CF>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 Format>Patterns and OK your way out.


Gord Dibben Excel MVP

On Wed, 14 Dec 2005 15:12:01 -0600, nicholea
<[email protected]> 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(D1>0,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