How to Create Messages in Excel-Part 2

How to create messages in excel-Part 2

 

In the previous article we have learnt how to create a Error message in the excel (Create Message Part 1)but sometimes we need to give Warning to the users.

Sample Scenario

Check the below excel here we have 2 columns and data in column B can be Yes or No as per the values available in drop down,

Note: You can check here(Create Dropdown Values in Excel) how to create drop down values in excel



Now to create the Message as an error proceed below

Step 1 Click on Data Validation tab and choose Data Validation

Step 2 click on the Error Alert Tab as shown

Step 3 Choose style as Warning

Step 4 Now enter Title and Error Message

Step 5 Press Ok button above and now you will return to the same initial screen

For e.g if I goto link 6 as above and try to make any change or right in it instead of selecting any value from Drop down option I get the following message.

Thus with above steps you can configure excel to give you a Warning pop up to user,the only difference between ERROR and WARNING message is that in ERROR message user can’t fill any value but with above option user can fill other value and continue.

This option is valid for cases where you are not sure of all the values in advance or at the time of creating excel so can choose this option.