if any cell is greater than cell + cell than

Microsoft Excel 010 - complete package
August 18, 2011 at 10:15:18
Specs: Windows 7
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.


See More: if any cell is greater than cell + cell than

Report •


#1
August 18, 2011 at 18:18:31

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.


Report •

#2
August 19, 2011 at 07:34:44
Thanks for the reply. It was just me ;-)

Report •

Related Solutions


Ask Question