How to Create Custom Error Message in Excel when value is negative
Create a custom error message in Excel to make help users input correct data and also to provide suggestions that are helpful in data input. Steps to create the custom error message Step 1 Open Excel, select the cell on which you want to create an error message. Fig 1 Step 2 Click on "Data" from the menu bar and go to "Data Validation" Fig 2 Step 3 Then this type of dialogue box will appear Fig 3 Step 4 Then click on " ˅ " as on figure, Then select " Whole number " Fig 4 Step 5 Then select "greater than" from next row and set minimum value to be "0" (zero) as on figure. Then click on "Input message" Fig 5 Step 6 Write the message that you want to display when you touch the cell. It will be displayed as on "fig 6.1" after all steps are completed. Fig6 Fig 6.1 Step 7 Then, click on "Error Alert", Write the message t...