Conditional Formatting in same column with multi criteria

I am trying to think my way through this and can't quite manage it yet.

I have a log that has stages but the criteria is based upon the substrate chosen.

If Hot dip is selected, the temperature spec is 120-160.

If Cold Rolled Steel is selected, the temp spec is 120-175.

I need the conditional formatting in the same cell, different specs but to turn red to alert the operators and managers of an "out of spec" condition.

Help appreciated!!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!