Select case on range name

Here is a very basic example of what I am trying to do. Essentially if the various criteria for each cell aren't met then the relevent msgbox should display