Can Excel Remind Me of Items Not Paid after x number of days?

I have large spreadsheet with colums which reflect Names, Amount Due (Column A), Dates of Invoice Sent(Column B) and Date of Request For Service ( Column C) .
Can excel remind me on the following:
1) When date of each invoice is more than 45 days old
2) When date of Request for Service is more than 30 days old

Thank you

What kind of reminder are you wanting? E-mail, a bright red cell stating REMINDER, a phone call?

Originally Posted by GregM56

a phone call?

hahah that would be useful.

There are definitely ways to 'remind' you if you mean a highlighted cell or a note on the cell adjacent etc. You would probably need to think about adding a column which states if that invoice has been dealt with, to prevent all old invoices flagging up (unless you plan to delete them).

To do it as a formula for a cell adjacent, you could do something such as

Please Login or Register  to view this content.

. If D39 was your cell with the date in, and it was over 30 days you needed reminding from.
To do it as a colour conditioning, you could select the cells with the dates in, select Conditional Formatting > New Rule > Use Formula. Then put

Please Login or Register  to view this content.

as the formula. Make sure the $D25 is the first cell in the list of dates, and that it ISN'T locked on both column and row (i.e., $D$25), as this will cause the formula to only look at that 1 cell rather than the column.

Does this help? Might be easier if you have an example book we can download.

I have attached a small sample of what I keep in excel. Color coding would be okay for any unpaid invoice over 45 days and
color coding would be okay for any request not completed after 30 days. If a column(s) for these two things could have number of days since
Invoiced date and number of days from date of request that are not completed, that would work for me.

no phone calls please.. lol

thanks. I will try the ones mentioned and let you know.