There is any auto email format?

R

Rohinikumar

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 can’t 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.
 
W

Wilpeter

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.
 
R

Rohinikumar

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?
 
R

Rohinikumar

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top