LinkBack URL
About LinkBacks
Dear All,
I have different columns in employees database, including passport details, but I need to create pop-up message for those passport going to expire before some days. Can any one guide me how to create it?
Thanks
Dear All,
I have different columns in employees database, including passport details, but I need to create pop-up message for those passport going to expire before some days. Can any one guide me how to create it?
Thanks
rather than popup message, which would requrie code, how about using conditional formatting?
plenty of examples of CF via search.
Thanks Andy, can you pls advice me how to do in Conditional Formating!
Cheers..
Lets say your data is from A2:J500 and you want the entire row to change to yellow if the passport will expire within 30 days. The passport date of receipt is in Column C and it expires 5 years from that date.
Select that range and go to conditional formatting.
"Formula is"Does that work for you?
Please Login or Register to view this content.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thanks, but i would like to get in the expiration date as a pop-up reminder. Can you advice me to create by using macro.
Something like this to test cells in B2:B12
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks