Is there any way to alert you when you are approaching a date?

T

Tee

I have an excel spreadsheet with due dates in a cell. Is there anyway to
alert the reader a week before that due date?
 
J

Jacob Skaria

1. Select the cel/Range...say ColA..
2. From menu Format>Conditional Formatting>
3. For Condition1>Select 'Formula Is' and enter the below formula
=AND(A1>0,A1<TODAY()+7)

Cell A1 in the above formula is the first cell in the selection
4. Click Format Button>Pattern and select your color (say Red)
5. Hit OK

If this post helps click Yes
 

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

Request Form - Alert Team Member 0
Conditional Date Alert 0
Alerts 0
Cannot Change Back to Previous Settings After Clicking "Try the new Outlook" 0
Publisher adding blank page when printing my booklet... 2
Alert on my Desktop or outlook from Excel worksheet on due dates 0
Report Group Footer DLookUp 0
Alert, Reminder 0

Top