Prev: Text to Columns
Next: Switched up to Excel 2007 lost functionality in my array equations
From: smack on 10 Feb 2010 14:54
I have a column where I enter a date when a document arrives. If it is left
blank for more than 7 days I need an alert. I also have a start date in A1
to refer to. It would be 7 days from the start date, I would need the cell
red or "ALERT".

Thanks!

SMack
From: Fred Smith on 10 Feb 2010 22:07
You want something like:
=today()>$a$1+7
Color the cell red. Displaying "ALERT" would require a macro.

Regards,
Fred


"smack" <smack(a)discussions.microsoft.com> wrote in message
news:549FC643-C7D3-483B-A8E5-04521FCD6F59(a)microsoft.com...
>I have a column where I enter a date when a document arrives. If it is
>left
> blank for more than 7 days I need an alert. I also have a start date in
> A1
> to refer to. It would be 7 days from the start date, I would need the
> cell
> red or "ALERT".
>
> Thanks!
>
> SMack

 | 
Pages: 1
Prev: Text to Columns
Next: Switched up to Excel 2007 lost functionality in my array equations