Forum Discussion
Unacceptable pop-out error formatting
Hi, I'm looking for a way to make a value that doesn't fit acceptable criteria to have a message pop-up to say error or unacceptable, etc. Say a reagent is out of stability, when the date is put in, I...
Maybe you're looking for data validation? Check out the following:
https://support.microsoft.com/en-us/office/apply-data-validation-to-cells-29fecbcc-d1b9-42c1-9d76-eff3ce5f7249
https://support.microsoft.com/en-us/office/apply-data-validation-to-cells-29fecbcc-d1b9-42c1-9d76-eff3ce5f7249
- Hi, I did manage to use the data validation to make a pop-up but unfortunately it only pops up when you type the date in. It doesn't work when copying and pasting the previous day's entry, which happens quite a bit. So say the reagent expired yesterday. So if the person copy and pasted from yesterday's entry it will still turn red since I set up conditional formatting but it won't have the error pop-up. Is there a way to make it pop-up if applicable when copying and pasting? Thanks for your help!
