Re: How do I set up alarms for expired dates in an excel spreadsheet?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Bob Phillips (bob.phillips_at_notheretiscali.co.uk)
Date: 10/06/04

Next message: Andy: "Re: SUMPRODUCT with multiple columns to sum"
Previous message: Bob Phillips: "Re: How do I permanently remove empty rows in excel"
In reply to: Frank Kabel: "Re: How do I set up alarms for expired dates in an excel spread***?"
Messages sorted by: [ date ] [ thread ]

Date: Wed, 6 Oct 2004 09:53:26 +0100

To test for about to expire, use something like

=A1-5<TODAY()

for 5 days, or whatever number you want

-- 
HTH
RP
"Frank Kabel" <frank.kabel@freenet.de> wrote in message
news:%23A%23LCB3qEHA.1816@TK2MSFTNGP09.phx.gbl...
> Hi
> I would use conditional formating for this and a formula within this
> dialog such as
> =A1<TODAY()
>
> --
> Regards
> Frank Kabel
> Frankfurt, Germany
>
> "bnp" <bnp@discussions.microsoft.com> schrieb im Newsbeitrag
> news:AFFC6EEB-B2E3-4D5A-8ED8-9A80021B7625@microsoft.com...
> > In a spread*** containing dates, i'd like to set up some sort of
> > flag/alarm, that will pop up when the date is about to expire?
>

Next message: Andy: "Re: SUMPRODUCT with multiple columns to sum"
Previous message: Bob Phillips: "Re: How do I permanently remove empty rows in excel"
In reply to: Frank Kabel: "Re: How do I set up alarms for expired dates in an excel spread***?"
Messages sorted by: [ date ] [ thread ]