Forum Discussion

Copper Contributor

Jun 20, 2019

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...

excel

Formulas and Functions

SergeiBaklan

Diamond Contributor

Jun 20, 2019

DanMRaycap

Could you give a sample how it looks like?

DanMRaycap
Copper Contributor
Jun 20, 2019

14.650 "+/-0.007" 14.665 14.650 14.650 14.650 14.650
SergeiBaklan
- SergeiBaklan
  Diamond Contributor
  Jun 20, 2019
  DanMRaycap
  
  That could be like
  
  Please check attached.
  Plus Minus CF.xlsx11 KB
  - DanMRaycap
    Copper Contributor
    Jun 20, 2019
    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
    
    SergeiBaklan
DanMRaycap
Copper Contributor
Jun 20, 2019
YesSergeiBaklan
- DanMRaycap
  Copper Contributor
  Jun 20, 2019
  
  1* 14.650 "+/-0.007" 14.665 14.650 14.650 14.650 14.650 14.653 0.006708
  DanMRaycap
  - DanMRaycap
    Copper Contributor
    Jun 20, 2019
    SergeiBaklan

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