Jun 20 2019 11:08 AM
I'm looking for help on a formula to apply conditional formatting to cells font color based on a cell +/- a tolerance in a first article sheet used in a metal or plastic manufacturing setting, can you help?
Jun 20 2019 11:14 AM
Could you give a sample how it looks like?
Jun 20 2019 11:23 AM
Jun 20 2019 11:25 AM
Jun 20 2019 11:32 AM
Jun 20 2019 12:39 PM
Thank you that's close, so I'm trying to make any of the 5 measurement cells turn red font IF they are Out of tolerance. IE A1 +/- .0007 = Red font IF not font stays Black.
DIMENSION/SPECIFICATION | SUPPLIER MEASUREMENTS | |||||
PART 1 | PART 2 | PART 3 | PART 4 | PART 5 | ||
14.650 | "+/-0.007" | 14.665 | 14.650 | 14.650 | 14.650 | 14.650 |
Jun 20 2019 12:57 PM
Where is A1 in this sample? And here only the cell under PART 2 shall be in red, correct?
Jun 20 2019 01:03 PM
Ok A1 is Dimension lets make it 1.0 and tolerance is +/- .0007.
So IF Measurement is In between 0.993 and 1.007 Font in the cell should remain, Black, IF the dimension is Not in the range it should turn Red for all 5 cells called supplier measurements, does that help? @Sergei Baklan
Jun 20 2019 01:04 PM
Jun 20 2019 01:24 PM
Nope, that fully different from your first sample and looks like
Is that one is the basis for the formula?
Jun 20 2019 01:32 PM
ITEM | DIMENSION/SPECIFICATION | SUPPLIER MEASUREMENTS | AVERAGE | STD DEV | ACC | REJ | METHOD or GAUGE | ASSET# | |||||
PART 1 | PART 2 | PART 3 | PART 4 | PART 5 | |||||||||
1* | 14.650 | "+/-0.007" | 14.665 | 14.650 | 14.650 | 14.650 | 14.650 | 14.653 | 0.006708 | DC |
In the example above Part#1 should have Red font if the formula is working correctly. @Sergei Baklan
Jun 20 2019 01:59 PM
Okay, like this
In A3 we have text "1*" and in C3 text "+/-0.007", in other cells in this row are numbers. Based on which formula we shall compare texts and numbers?