# Conditional Formatting Formulas

Highlighted
Occasional Contributor

# 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 you help?

13 Replies
Highlighted

# Re: Conditional Formatting Formulas

Could you give a sample how it looks like?

Highlighted

Highlighted

# Re: Conditional Formatting Formulas

 1* 14.65 "+/-0.007" 14.665 14.65 14.65 14.65 14.65 14.653 0.006708
Highlighted

Highlighted

# Re: Conditional Formatting Formulas

 14.65 "+/-0.007" 14.665 14.65 14.65 14.65 14.65
Highlighted

# Re: Conditional Formatting Formulas

That could be like

Highlighted

# Re: Conditional Formatting Formulas

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

Highlighted

# Re: Conditional Formatting Formulas

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

Highlighted

# Re: Conditional Formatting Formulas

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

Highlighted

# Re: Conditional Formatting Formulas

=IF(D10>(\$B\$10+\$C\$10),Red,))IF(D10<(\$B\$10+\$C\$10),Red,))
Highlighted

# Re: Conditional Formatting Formulas

Nope, that fully different from your first sample and looks like

Is that one is the basis for the formula?

Highlighted

# Re: Conditional Formatting Formulas

 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

Highlighted

# Re: Conditional Formatting Formulas

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?