Hi All,

I know some one can help me in this regard, that I am using excel for
Insurance expiry date list more then 2000 list I have. Now what my question
is everyday I cant able to find every expiry date. I want some solution from
that if there is any formula like if insurance date was expired how can I get
the email for me? Like the date is 8/3/2010 and number is 123456 at the same
day automatically I want email from for warning so that I can renewal the
same.

If there is any formula or something pls help me. I am very struggling for
this.

Have you tried Conditional Format? For the Expiry Date column, use
FORMAT, Conditional Format, Cell Value is Greater than or Equal to, =Today()
and set the actual Pattern to Color Red.

"Rohinikumar" wrote:

Hi All,

I know some one can help me in this regard, that I am using excel for
Insurance expiry date list more then 2000 list I have. Now what my question
is everyday I cant able to find every expiry date. I want some solution from
that if there is any formula like if insurance date was expired how can I get
the email for me? Like the date is 8/3/2010 and number is 123456 at the same
day automatically I want email from for warning so that I can renewal the
same.

If there is any formula or something pls help me. I am very struggling for
this.

Hi Wilpeter i have done that..but everyday i have to check which was in red
colour.....if there is any chance to get an email if date was expired?

"Wilpeter" wrote:

Have you tried Conditional Format? For the Expiry Date column, use
FORMAT, Conditional Format, Cell Value is Greater than or Equal to, =Today()
and set the actual Pattern to Color Red.

"Rohinikumar" wrote:

Hi All,

I know some one can help me in this regard, that I am using excel for
Insurance expiry date list more then 2000 list I have. Now what my question
is everyday I cant able to find every expiry date. I want some solution from
that if there is any formula like if insurance date was expired how can I get
the email for me? Like the date is 8/3/2010 and number is 123456 at the same
day automatically I want email from for warning so that I can renewal the
same.

If there is any formula or something pls help me. I am very struggling for
this.

Hi Wilpeter i have done that..but everyday i have to check which was in red
colour.....if there is any chance to get an email if date was expired?

"Wilpeter" wrote:

Have you tried Conditional Format? For the Expiry Date column, use
FORMAT, Conditional Format, Cell Value is Greater than or Equal to, =Today()
and set the actual Pattern to Color Red.

"Rohinikumar" wrote:

Hi All,

I know some one can help me in this regard, that I am using excel for
Insurance expiry date list more then 2000 list I have. Now what my question
is everyday I cant able to find every expiry date. I want some solution from
that if there is any formula like if insurance date was expired how can I get
the email for me? Like the date is 8/3/2010 and number is 123456 at the same
day automatically I want email from for warning so that I can renewal the
same.

If there is any formula or something pls help me. I am very struggling for
this.