How to Create Messages in Excel –Part 3

How to create messages in excel –Part 3

In the previous article we have learnt how to create a Error/Warning message in the excel (Create Messages in Excel Part 2)but sometimes we need to give Information only 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 how to create drop down values in excel

http://saxenablogs.blogspot.com/2010/05/data-validation-in-excel-how-to-create.html

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 Information

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 Information pop up to user,the only difference between ERROR and Information 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 want to guide users to fill the right option from drop down and not to enforce them for choosing only same set of values.