Anbuselvam K
Member
Dear Excel Genius
I want to pop up a message when the cells have negative values. To achieve that I used Data Validation > Decimal > Between > Error Message like below snapshot.
After applying the data validation, I got pop up when I entered the negative values manually like below snapshot.
But the problem is when the cell gets negative values by its formula, it is not pop up the error message. see the below GIF.
Please guide me to get the pop-up error message with its formula.
I want to pop up a message when the cells have negative values. To achieve that I used Data Validation > Decimal > Between > Error Message like below snapshot.
After applying the data validation, I got pop up when I entered the negative values manually like below snapshot.
But the problem is when the cell gets negative values by its formula, it is not pop up the error message. see the below GIF.
Please guide me to get the pop-up error message with its formula.