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!
Answers
-
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.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
How would I exclude values that are "1"? Its highlighting the 100% and the "1" values
-
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.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 213 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!