Can I set up an excell spreadsheet to notify me when a suspense goes overdue?
T Tricky Jan 12, 2005 #1 Can I set up an excell spreadsheet to notify me when a suspense goes overdue?
D Dave Peterson Jan 13, 2005 #2 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.
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.