Unacceptable pop-out error formatting

[Sharon_Dquest1]

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 want a comment to pop-up and say something like out of stability. Is that doable?

[#2]

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-ef...

[#3]

@Sharon_Dquest1 

Here are some simple examples, with and without VBA.

Please see the examples in the attached file.

I would be happy to know if I could help.

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

[#4]

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!