Forum Discussion
Conditional Formatting Formulas
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 yo...
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 |
Where is A1 in this sample? And here only the cell under PART 2 shall be in red, correct?
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? SergeiBaklan
Nope, that fully different from your first sample and looks like
Is that one is the basis for the formula?