Forum Discussion

DanMRaycap's avatar
DanMRaycap
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
DanMRaycap's avatar
DanMRaycap
Copper Contributor
Jun 20, 2019

 

14.650"+/-0.007"14.66514.65014.65014.65014.650

SergeiBaklan 

  • DanMRaycap's avatar
    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/SPECIFICATIONSUPPLIER MEASUREMENTS
    PART 1PART 2PART 3PART 4PART 5
    14.650"+/-0.007"14.66514.65014.65014.65014.650

     

    SergeiBaklan 

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Jun 20, 2019

      DanMRaycap 

       

      Where is A1 in this sample? And here only the cell under PART 2 shall be in red, correct?

      • DanMRaycap's avatar
        DanMRaycap
        Copper Contributor
        Jun 20, 2019

        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 

Resources