How to change font color depending results
Hi,
I created test with Smartsheet formula. I got a column for the result. I would like to know how to write my formula in that column for the font to change color.
For example, everything equal or higher than 60% is green 59% or less is red.
Thanks
Best Answer
-
Hello, @Indianaduck ! You want Conditional Formatting rather than a formula for this task. Using your example, below is a screenshot of how your conditional formatting rules would be set.
This screenshot shows the outcome of this conditional formatting.
I hope this helps!
Amber
Amber Eakin, MSLS, M.Ed.
Adult Education Specialist | Process Improvement Enthusiast
Answers
-
Hello, @Indianaduck ! You want Conditional Formatting rather than a formula for this task. Using your example, below is a screenshot of how your conditional formatting rules would be set.
This screenshot shows the outcome of this conditional formatting.
I hope this helps!
Amber
Amber Eakin, MSLS, M.Ed.
Adult Education Specialist | Process Improvement Enthusiast
-
Thanks
It's saving my life!!
-
@Indianaduck I'm glad it's working for you!
Amber Eakin, MSLS, M.Ed.
Adult Education Specialist | Process Improvement Enthusiast
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!