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

LAKE, Joe (ISLAND CITY PRACTICE) 25 Reputation points
2024-01-30T09:07:28.3+00:00

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

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,328 questions
{count} votes

Accepted answer
  1. Emi Zhang-MSFT 20,576 Reputation points Microsoft Vendor
    2024-01-31T02:52:11.1833333+00:00

    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:

    User's image

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

    User's image

    The Result will showing:

    User's image

    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.

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
  1. Zahid Butt 556 Reputation points
    2024-01-30T13:47:29.9766667+00:00