RE: Date/If function for past dues

hi,
forgot to mention.
highlight the a column and conditional fomat the whole column.

regards
FSt1

"FSt1" wrote:

> hi,
> in column E you could put
>
> =if(A2<Now(), "Overdue","")
>
> or you could use conditional formating.
> go Format>conditional format
> enter Cell value is less than =now()
>
> then click the format button>patterns. pick a bright color to high light
> the overdue cell.
>
> regards
> FSt1
>
> "workin4alivin" wrote:
>
> > I want to be able to put in a formula that will tell me if a loan recipient's
> > loan is past due.
> >
> > Column A is payment due date
> > Column B is payment amount due
> > Column D is acutal date payment is rec'd
> > Column E is actual amount received
> >
> > Any help that anyone can offer will be appreciated, including a formula that
> > will work or a different way to set up my workbook to give me what I want.
> > (Essentially, I have a page for each borrower and a summary *** on the
> > front page that shows original loan balance, balance due, late payments,
> > etc.)
> >
> > Thank you, Tara
.