reminders

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created an excel spreadsheet and I have the acct #'s in column A and the dates that theacct's were sent to our New Acct. Team to be profiled in column B. Approx. one week from now, I have to follow-up to make sure a new acct has bee
opened. How can I set up a formula to highlight the acct #(red or yellow etc) as a reminder one week from the date entered to remind me to follow up? I can have approx. 100 acct's a week and it's a lot to follow up and woul
be nice to have a reminder.
 
First, In the future this question or one like it would
best be posted in the Excel groups. However, what you
want to do is use Conditional Formating on the date cells
that can compare those dates to the current date. The
Excel help files should be able to help you with the
process. HTH.

AJ

-----Original Message-----
I created an excel spreadsheet and I have the acct #'s in
Click to expand...
column A and the dates that theacct's were sent to our New
Acct. Team to be profiled in column B. Approx. one week
from now, I have to follow-up to make sure a new acct has
been
opened. How can I set up a formula to highlight the acct
Click to expand...
#(red or yellow etc) as a reminder one week from the date
entered to remind me to follow up? I can have approx. 100
acct's a week and it's a lot to follow up and would
 
Back
Top