A
Andi
I'm running excel2003 on windows xp, using Netscape 7.1 as the email
application. I have an .xls that contains the date a check was issued.
There are a few hundred entries and the list is getting bigger. 90 days
after the checks are issued, I need to send reminders to the checkholders
reminding them to report on expenditures. Currently, I have conditional
formatting that highlights cells when I open the workbook based on the issue
date =today()>=(A1+90) . However, keeping up with which highlighted
cells are new without looking through the whole xls is getting more
difficult. Is there a way to have a pop-up notice telling me which cells are
newly due, or an email reminder letting me know? I am willing to convert my
xls to access or use other software if possible/necessary. Thanks in advance
for your help!
application. I have an .xls that contains the date a check was issued.
There are a few hundred entries and the list is getting bigger. 90 days
after the checks are issued, I need to send reminders to the checkholders
reminding them to report on expenditures. Currently, I have conditional
formatting that highlights cells when I open the workbook based on the issue
date =today()>=(A1+90) . However, keeping up with which highlighted
cells are new without looking through the whole xls is getting more
difficult. Is there a way to have a pop-up notice telling me which cells are
newly due, or an email reminder letting me know? I am willing to convert my
xls to access or use other software if possible/necessary. Thanks in advance
for your help!