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

Find more posts tagged with

Accepted answers

All comments

Kelly Gabel

That one is the Net Promoter Score, the Plan and Actual rows from January through the end of the year. In the chart, though, I only show the months, no quarter averages, etc.

Paul Newcome

Are you including the [Data Type] column when you select the data for the chart?

Kelly Gabel

No, but I can...and I see where you are going with that :) I will give that a try. Thanks!

Paul Newcome

Feel free to let me know if it works. If you look under the "Chart & Data" tab in the Chart Builder, you can use the "Select Columns" button to exclude those couple in between since you have to select a single range for the chart.

Kelly Gabel

Once again you rock :) Thanks @Paul Newcome !

Paul Newcome

Happy to help. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.