How do i create a notification in excel when item quantity reaches a certain number

Question

How do i create a notification in excel when item quantity reaches a certain number

Answer 1

Hi,

You can try to use the Data Validation to get the result you need.

Select the Range you need- go to Data- Data Validation- Settings tab- Select Custom and enter the formula you need:

Select Error Alert tab- enter the Title and Error message you need to pop up:

The Result will showing:

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

---

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi, Please go through below link, you may achieve this by conditional formatting: https://support.microsoft.com/en-us/office/use-conditional-formatting-to-highlight-information-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f#:~:text=1%20Select%20the%20cells%20that%20you%20want%20to,text%2C%20or%20border%20color%29%2C%20and%20then%20click%20OK. Regards,