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 Formatconditional format
enter Cell value is less than =now()
then click the format buttonpatterns. 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 sheet on the
front page that shows original loan balance, balance due, late payments,
etc.)
Thank you, Tara
|