Can I set up an excell spreadsheet to notify me when a suspense goes overdue?
Can I set up an excell spreadsheet to notify me when a suspense goes overdue?
Hi!
I don't know your context, but you can use conditional formating to colour cells if the date in them is earlier than today's date (as held in your computer). Would this help?
Alf
Maybe you could put a formula in an adjacent cell to the due date.
=IF(A1<TODAY(),"Overdue","ok")
Format it big, bold, red letters.
Tricky wrote:
>
> Can I set up an excell spreadsheet to notify me when a suspense goes overdue?
--
Dave Peterson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks