How do I create a prompt box?

T

trevor

I’m trying to create promote box in excel to show that 3 months before the
expiry date. To say that “3 months before expiry consider for renewingâ€.

Then a day before expiry “1 day before pass expiriesâ€

And after the expiry date “Need reviewingâ€

Column C2:C90 – are were the dates are stored and need to do a promote box
with these 3 conditions.
And would like to have a promote box appear with the name and expiry showing
or even to colour the cell when 3 month before, 1 day before and after the
expiry date
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top