I am trying to create a function which will let me know when a particular
date has passed or expired. For example, a person has insurance which
expires on 4/30/06 - I want something that will let me know on 4/31/06 that
that person's insurance is expired. Maybe also create a macro that will
automatically filter all the expired's. Is there anyway to do this? I
tried VLOOKUP, I tried an IF function, but I'm just not sure exactly how to
write this.

Thanks a million!

take a look at conditional formatting:

Select the column with the dates

FormatConditional Formatting

Cell Value Is Greater than =NOW()
Format Colour = Red

OK





"Laura N" wrote in message
. ..
I am trying to create a function which will let me know when a particular
date has passed or expired. For example, a person has insurance which
expires on 4/30/06 - I want something that will let me know on 4/31/06
that
that person's insurance is expired. Maybe also create a macro that will
automatically filter all the expired's. Is there anyway to do this? I
tried VLOOKUP, I tried an IF function, but I'm just not sure exactly how
to
write this.

Thanks a million!

p.s. - maybe you should also have 28 days notice:

Cell Value Is Greater than =NOW()-28

Format Colour = Amber



"JethroUK©" wrote in message
...
take a look at conditional formatting:

Select the column with the dates

FormatConditional Formatting

Cell Value Is Greater than =NOW()
Format Colour = Red

OK





"Laura N" wrote in message
. ..
I am trying to create a function which will let me know when a
particular
date has passed or expired. For example, a person has insurance which
expires on 4/30/06 - I want something that will let me know on 4/31/06
that
that person's insurance is expired. Maybe also create a macro that will
automatically filter all the expired's. Is there anyway to do this? I
tried VLOOKUP, I tried an IF function, but I'm just not sure exactly how
to
write this.

Thanks a million!