How do I create a pop up warning box with cell information?

  • Thread starter Thread starter Rikki727
  • Start date Start date
R

Rikki727

I'm trying to set up a worksheet for our company's skills matrix. When the
expiry date for a certain item is less than 50 days away I want a pop up
warning box displaying which item for which employee is about to expire and
how many days are left.
 
We can use conditional formatting. For example if the expiration date is in
B1, then in C1 enter:

="expiration in " & B1-TODAY() & " days"

Then format C1 like:

Format > Conditional Formatting... > Formula is>
=B1-TODAY()>50
and pick a font color to match the background color.

This warning will be invisible until you approach the expiration 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

Similar Threads

Emailing formula results 1
Pop up message to warn of date expiring? 7
How to highlight cells if it passes a set date? 6
How do I change a pop-up dialog box in an Excel cell? Not comment 1
pop up box 2
macro for excel msg pop up when certain conditions are met 4
How create a pop up information box 1
How to have errr msg pop up when user clicks on locked cell 4

Back
Top