Need nominal data indication

You really should decide the exact method, based on your data and how you want to present it. Whether you use line, bar, etc., depends on what your data means. We can certainly make a recommendation, but to do so we would need to understand more about the nature of your data.

Also, you need to provide a file with sample data.

For most solutions, you will almost certainly have to create a second column using formulas to select the data outside the desired range to be highlighted. It may also require a third column showing the data that is within the range.

If you use a line chart, you can plot the second column using no line and with markers that are large empty circles that would appear to circle the points outside the range.

If you use a column chart you would need the third column so you could plot the normal points in one color and the other points in another color. I would use a stacked bar chart for that.

You can plot range limit lines horizontally to show the upper and lower limits, but I'm not sure how you would apply shading to those (although it might be possible).

The first recommendation for "conditional formatting" of chart data is something like this: http://peltiertech.com/conditional-f...-excel-charts/ As Jeff indicates, this is more about formulas in the spreadsheet rather than the chart itself. http://peltiertech.com/conditional-f...-excel-charts/

Here is a revision to your file that circles the points that are out of range. I converted the chart to a Scatter Plot with connecting lines. Then I added a column with Out Of Range values and plotted that as an additional series. Then I formatted it to have no line, and large markers with no fill.

Again, without knowing more about your data I can't say whether a line chart if the best way to depict it. Are you trying to show a trend over time? Or distribution of random samples? Or something else?