Chapter-9: Error Alert in Data Validation

After putting the data validation in excel cells whenever an invalid value is entered in the excel cell, It shows “The value you entered is not valid“.

We can display our own text in place of  “The value you entered is not valid” while entering the invalid entry in excel cell.

Below are the steps to change Error Alert in Data Validation:

  • Select the range.
  • Go to Data tab>>Data Validation>>Click on Data Validation.
Data Validation Option
Data Validation Option
  • Below given window will be opened.
  • Put the your data validation in Setting tab like in below image Date Validation has been taken to enter the date greater than “1-Jan-18“only.
  • Click on Error Alert Tab.

 

Setting Tab in Data Validation window
Setting Tab in Data Validation window
  • Put the Title and Error message in the boxes available in Error Alert tab in Data Validation Window.

There are 3 types of Style available in the Error Alert tab – Stop, Warning and Information.

1.Stop:

Stop style will not allow user to enter the invalid entry.

Error Alert Tab in Data Validation Window
Error Alert Tab in Data Validation Window

It will show the defined error massage along with the Stop sign, Retry, Cancel and Help button.

Stop Style Error Message
Stop Style Error Message

2.Warning:

Warning style will show a warning while entering invalid entry but it will give an option to enter the invalid value.

Warning Style Error Message
Warning Style Error Message

It will show the defined error massage along with the Warning sign, Yes, No, Cancel and Help button. If user clicks on Yes button then invalid value will be entered in the excel cell.

Warning Style Error Message
Warning Style Error Message

2.Information:

Information style will show an information popup while entering invalid entry.

Information Style Error Message
Information Style Error Message

It will show the defined error massage along with the Information sign, OK, Cancel and Help button. If user clicks on OK button then invalid value will be entered in the excel cell.

Information Style Error Message
Information Style Error Message

 

Next ChapterPrevious Chapter