I have a workbook that I am trying to configure with the following: 1. Base line calulcation

2. Test product up to 10 times and input values after each test

3. If product changes by greater than "X" from baseline than fail (change color) and put X in failed column.Example:

Test 1: Baseline of .003

Tolerance to fail = >Base+.002

1st Test measurement = .003

2nd Test = .0035

3rd Test = .004

4th Test = .004

5th Test = .0065 (which would trigger the fail)

No more testing required since failed.I have tried conditional formatting but to no avail. Maybe it is me.

Hopefully this makes sense. Any help would be appreciated.

re: "I have tried conditional formatting but to no avail"I guess you didn't try hard enough! ;-)

With your base case in A1 and your 10 tests in B1:K1, enter this formula in L1:

=IF(COUNTIF(B1:K1,">"&A1+0.002)>0, "X", "")

Use this for the Conditional Formatting rule:

=COUNTIF(B1:K1,">"&A1+0.002)>0

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Thanks for the reply. It was just me ;-)

Ask Your Question

Weekly Poll