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