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

  • Thread starter Thread starter Tee
  • Start date Start 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?
 
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
 
Back
Top