In "citehr.com" one forum member had following issue: Aejaz.K Started The Discussion: Hi, I Have Excel Sheet Containing The Passport Details Such As Issue & Expiry. I Would Like Set Reminder Before The Expiry Date. I Have Been Trying On My Own But Couldn\'T Get The Desired Result. Need Your Help Thanks In Advance" http://www.citehr.com/391303-passport-expiry-reminder-excel-xls-download.html The above issue simply can be sorted out with the function of IF and Conditional Formatting. Find attached herewith the excel file. User only need to put Expiry Date in corresponding cells relating to Passport and Entry Visa Column ( column J and N). The function will automatically calculate Expiry Status. If the status is expired then respective row range will be highlighted with Red Color
0 Comments
|
|