Conditional Formatting with percentages

Hello all!

I am wondering if there is a way to use the conditional formatting with percentages. For example, I have a report with inconsistent data in each column (some percentages, some just numbers). When I try to condition as greater than 90%, greater than .90, or greater than 90 it includes the full numbers as well instead of just the percentages

Thank you for any help you may be able to provide!

Find more posts tagged with

Conditional Formatting

Accepted answers

All comments

Paul Newcome

You would need to include an argument to look at the number being both grater than .9 and also less than or equal to 1.

Kaitlyn.kemp

How would I exclude values that are "1"? Its highlighting the 100% and the "1" values

Paul Newcome

Unfortunately that is going to require manual intervention where you insert a helper checkbox column and manually check the box on rows that contain an actual percentage. You would then incorporate this into the same conditional formatting rule to only highlight cells that are between .9 and 1 and have the box checked.

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.