• 409K Members
• 6,479 Online
• 466K Conversations

## Conditional Formatting Formulas

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

# Re: Conditional Formatting Formulas

Could you give a sample how it looks like?

# Re: Conditional Formatting Formulas

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

# Re: Conditional Formatting Formulas

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

# Re: Conditional Formatting Formulas

That could be like

# 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

# Re: Conditional Formatting Formulas

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

# 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

# Re: Conditional Formatting Formulas

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

# Re: Conditional Formatting Formulas

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

Is that one is the basis for the formula?

# 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

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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies