Using the Error Alert tab


show more Using the Error Alert tab provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2010: Data Validation in Depth show less
please wait ...

Using the Error Alert tab

In this worksheet, column B has data validation criteria set up. And as I click in cell B2, I see the pop-up reminder, so I am not going to type in a value below 30,000 or above 90,000. So, I will type in a number, for example, for the particular cell I'm looking at, 43,218. Not a problem. I've got another cell, and I am looking at my sheet of paper here. It's $67,509.50. Enter. And the error message here is pretty generic.

It says it's not valid, and I'm saying to myself, "Well, it falls between the range. I wonder what's going on here." I can't figure out what's happening here. What do we need to do in the example here? If we were to cancel and then jump to data validation, we will see the rules, and what we might have overlooked and it might take us a while is that this must be a whole number. It wouldn't have made sense possibly for the input message to say that, we certainly could alter this and that might be one approach. Another approach c...

Using the Error Alert tab
Video duration: 2m 34s 59m 45s Intermediate

Viewers:

Using the Error Alert tab provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2010: Data Validation in Depth

Subject:
Business
Software:
Excel
Author:
please wait ...