Checking a number of measurements against constantly changing high and low tolerences.

[Ishcor]

In my work I take around 100 different measurements. Each measurement has it's own spec for high and low tolerance. For example measurement #1 can be between 0 and 1. Measurement #4 could be between 0 and 1.5 and so on. I use conditional formatting to highlight the measurements that are out of spec, but then I have to manually count each highlighted cell to give an overall report. I'm wondering it I could automate the process to give me a total count of each out of spec measurement. I'm wondering if anyone has suggestions on how I can do that. I have an example below on how the spreadsheet is organized. Keep in mind that I can't reorganize any of the measurements and this is only a small example of the 100 measurements that are done.

Measurement number		#1	#2	#3	#4	#5	#6	#7	#8
High tolerance	1	1	1	1.5	3.5	1	2	1
Low tolerance	0.1	0.1	0.1	0	0	0	0	0
Reading		0.5	0.2	1.1	0.1	3.1	1	1.5	0.5				Count out of spec	1

<colgroup><col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:3108;width:64pt" width="85"> <col style="width:48pt" width="64" span="14"> </colgroup><tbody>
</tbody>

 

[JoeMo]

Excel Workbook
	A	B	C	D	E	F	G	H	I	J
1	Measurement number	#1	#2	#3	#4	#5	#6	#7	#8	Out of Spec
2	High tolerance	1	1	1	1.5	3.5	1	2	1
3	Low tolerance	0.1	0.1	0.1	0	0	0	0	0
4
5	Reading1	0.5	0.2	1.1	0.1	3.1	1	1.5	0.5	1
6	Reading2	0.3	0.05	0.8	0	3.7	1.2	1.9	1.3	4
Sheet1