Help.

I have tried and tried to solve the logic of Pass/Fail to applicable
tolerances:

The table of tolerances are

Situation A Situation B

<= 60 = +20 -20 +30 -20
80 = +20 -20 +30 -30
100 = +30 -30 +40 -40
=120 = +40 -40 +40 -40

All I need to do is measure the number of results that are out of tolerance
in a list (up to 1500 records). I envisage dedicating a column to fill with
"0"/"1" or "TRUE"/"FALSE" or "PASS"/FAIL".

I have spent many hours on this problem and am no nearer to solving the
logic than when I started. Has anyone encountered a similar situation? Or
can someone "see" the logic?

I would be even more impressed if someone can help with how to "highlight"
in Conditional formatting so the Pass/Fail can be detected at the time of
data entry. This is less important than counting the "failures".

Thanking any of you wonderful experts in grateful anticipation.

sincerely

Jeff Smith