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

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

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

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

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

If this post helps click Yes
---------------
Jacob Skaria


"Tee" wrote:

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

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

Yes. Look at help for "Conditional Formatting".
--
David Biddulph

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