reminders

A

AJ Raiber

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formating a row based on one cell's date 3
Space at end of multi page list to accommodate new entries 1
Output Date Grouping 1
Subtracting two cell dates and highlight if over due by a certain amount of days 0
Cobditional Formatting Rows based on dates in action plan. 0
comparing fields help needed 0
create new table from Multiple Criteria in multiple columns 4
Retrieving data into worksheet from another worksheet in same work 2

Top