Hi I'm a quality engineer and I need to prevent inspectors of our product entering results into the spreadsheet we use and then finding out it does not meet requirements after confirming the product is ok when it is actually not.
I'm looking for a formula to work with conditional formatting.
We have a specification for set products in our catalogue with set tolerances which will fall between a range. I want the cell to light up red when it falls outside this range.
To add to this, the range has to be based on a tolerance for a particular product which will be in another sell on the same row. Let me give you an example.
Product A has a tolerance between 100 - 200.
Product B has a tolerance between 150 - 250.
I guess the formula in my head would be something like this:
=IF Cell A5=Product A - Range = 175 - This would not trigger conditional formatting.
=IF Cell A5=Product A - Range = 135 - This would trigger conditional formatting.
Thanks so much in advance, this has been bugging me for months.
Bookmarks