+ Reply to Thread
Results 1 to 9 of 9

I want excel formula for highlight expired dates

  1. 06-12-2017, 05:35 AM #1
    tariqjahangir
    tariqjahangir is offline
    Forum Contributor
    Join Date
    12-30-2014
    Location
    Saudi Arabia
    MS-Off Ver
    2013
    Posts
    144

    I want excel formula for highlight expired dates

    Dear Excel Forum Member

    Iam Looking for excel formula for date expired for (ID CARD) kindly help me data sheet attached,

    Thanks

    ID CARD.xlsx
    Reply With QuoteRegister To Reply
  2. 06-12-2017, 06:14 AM #2
    Punnam
    Punnam is offline
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Office 365
    Posts
    1,899

    Re: I want excel formula for highlight expired dates

    HI try this
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    Punnam
    Reply With QuoteRegister To Reply
  3. 06-12-2017, 06:49 AM #3
    tariqjahangir
    tariqjahangir is offline
    Forum Contributor
    Join Date
    12-30-2014
    Location
    Saudi Arabia
    MS-Off Ver
    2013
    Posts
    144

    Re: I want excel formula for highlight expired dates

    Quote Originally Posted by Punnam View Post
    HI try this
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    Punnam
    Thanks for your reply could you please how to highlight expired date with data validation ( if possible you cand apply my excel file) iam waithing for your quick responce once again thanks ( Hello sir iam also from hyderabad Malakpet )
    Last edited by tariqjahangir; 06-12-2017 at 06:51 AM.
    Reply With QuoteRegister To Reply
  4. 06-12-2017, 06:54 AM #4
    Punnam
    Punnam is offline
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Office 365
    Posts
    1,899

    Re: I want excel formula for highlight expired dates

    why do yo require data validation , explain
    You want all the expired visa based on current date ?
    Reply With QuoteRegister To Reply
  5. 06-12-2017, 07:03 AM #5
    Punnam
    Punnam is offline
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Office 365
    Posts
    1,899

    Re: I want excel formula for highlight expired dates

    Check this
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 06-12-2017, 07:30 AM #6
    tariqjahangir
    tariqjahangir is offline
    Forum Contributor
    Join Date
    12-30-2014
    Location
    Saudi Arabia
    MS-Off Ver
    2013
    Posts
    144
    Quote Originally Posted by Punnam View Post
    why do yo require data validation , explain
    You want all the expired visa based on current date ?
    Sorry conditional formatting
    Reply With QuoteRegister To Reply
  7. 06-12-2017, 07:31 AM #7
    Punnam
    Punnam is offline
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Office 365
    Posts
    1,899

    Re: I want excel formula for highlight expired dates

    I have made the changes in my post 5 check it once
    Reply With QuoteRegister To Reply
  8. 06-14-2017, 05:34 AM #8
    tariqjahangir
    tariqjahangir is offline
    Forum Contributor
    Join Date
    12-30-2014
    Location
    Saudi Arabia
    MS-Off Ver
    2013
    Posts
    144

    Re: I want excel formula for highlight expired dates

    Thanks Punnam is it possible to create notification on PC when pc will start need to display notification ( following ID Card has expiry soon ) like that kindly give me reply thanks
    Reply With QuoteRegister To Reply
  9. 06-14-2017, 07:25 AM #9
    Punnam
    Punnam is offline
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Office 365
    Posts
    1,899

    Re: I want excel formula for highlight expired dates

    I am not sure close this thread and start new thread "Desktop Notification Macros from excel " if possible someone come and help you in this regard
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula for counting if someone dates expired and no future date booked in
    By ailismanzoni in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-27-2017, 06:49 AM
  2. i need to get a pop up message in excel to see the expired dates of contract
    By benoy2742 in forum Excel General
    Replies: 1
    Last Post: 09-26-2016, 10:23 AM
  3. Conditional Formatting to highlight expired and upcoming dates
    By hongman in forum Excel General
    Replies: 7
    Last Post: 02-24-2016, 11:34 AM
  4. conditional formatting to highlight when expired
    By lialkos in forum Excel General
    Replies: 2
    Last Post: 01-10-2014, 09:24 AM
  5. Conditional formatting formula to check expired\old dates
    By Kimston in forum Excel General
    Replies: 5
    Last Post: 12-31-2011, 04:33 AM
  6. [SOLVED] automatically highlight cells with expired dates?!
    By cwest123456 in forum Excel General
    Replies: 2
    Last Post: 08-01-2005, 02:05 PM
  7. How do I highlight expired dates automatically in excel.
    By adam in forum Excel General
    Replies: 1
    Last Post: 07-31-2005, 06:05 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1