+ Reply to Thread
Results 1 to 4 of 4

Alert message via data validation

  1. #1
    Registered User
    Join Date
    04-14-2015
    Location
    India
    MS-Off Ver
    2013
    Posts
    127

    Alert message via data validation

    Hi all,

    I google & did not find the solution.

    I want an alert before expiry date before 1 months time.

    say: Project start date 1-1-2014 & end date is 12-31-2014; Ans should be 12-1-2014

    Regards,
    Vikas

  2. #2
    Forum Contributor LokeshKumar's Avatar
    Join Date
    03-31-2015
    Location
    India
    MS-Off Ver
    All, mostly 2010 now..
    Posts
    471

    Re: Alert message via data validation

    Hi,

    Use the following.....
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    If your question is resolved, mark it SOLVED using the thread tools. Click on the star if you think some-1 helped you.
    Lokesh Kumar
    Stay Hungry.. Stay Foolish..
    _________________________________________________________
    Please Click STAR to Add Reputation if my/someone's answer helped!

  3. #3
    Forum Contributor
    Join Date
    12-19-2012
    Location
    Bengaluru
    MS-Off Ver
    Excel 2013
    Posts
    108

    Re: Alert message via data validation

    Hi Lokesh,

    The formula should be in the following way. Please correct me if I'm wrong.

    Please Login or Register  to view this content.

  4. #4
    Forum Contributor LokeshKumar's Avatar
    Join Date
    03-31-2015
    Location
    India
    MS-Off Ver
    All, mostly 2010 now..
    Posts
    471

    Re: Alert message via data validation

    Quote Originally Posted by kittu55 View Post
    Hi Lokesh,

    The formula should be in the following way. Please correct me if I'm wrong.

    Please Login or Register  to view this content.
    Yes you r right just a typo error..

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Name Manager: How to copy data from one sheet to another while avoiding alert message
    By lukelucky in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-02-2015, 12:11 PM
  2. Data Validation Alert with Formula
    By jlo33 in forum Excel General
    Replies: 1
    Last Post: 10-29-2013, 01:05 PM
  3. New message alert... doesn't ALERT me very well
    By Xx7 in forum Outlook Formatting & Functions
    Replies: 6
    Last Post: 07-20-2011, 03:54 PM
  4. Data validation / warning alert
    By Chemistification in forum Excel General
    Replies: 4
    Last Post: 09-01-2010, 11:57 AM
  5. Data Validation Information Alert
    By RunHard in forum Excel General
    Replies: 2
    Last Post: 07-01-2009, 09:56 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1