expiry

Hi, sorry if been asked before, but need a slight more dumbed down answer. I’ve got a spreadsheet that records insurance and expiry dates. What I would like to do if possible, is that say around 5 days before the expiry date I could have a visible reminder, I.e. the expiry date turns red for...

I am trying to set formatting for when a certificate is due to expire. I have put a today formulae in one cell for current day. In another cell I have an expiry date (there is multiple cells in the column each with different expiry dates) I want either of these cells to highlight different...

I've been using MrExcel for years but always found what I needed and never had a need to post before. I was hoping someone could help me with a strange request: Does anyone know of a method of have the code that I could use to force a user to change the workbook Password every 90 days? and...

Hi there, I'm just looking for help with some data keeping. I have a list of employees that require certain courses to be up to date and would like a function etc that will generate a list of courses that will expire within a month and the employee it corresponds to. Thanks. Mark

hi people, Ive been trying to do this for ages now, but decided i need further help! Im fairly new to VB but getting the hang of it, however this one gets passed me. I have made a spreadsheet that works out figures and conversion rates and stuff, however i would like it to expire with the...