Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Changing the Color of a Font Based on Values
Hi All
I'm building a budget sheet and am trying to figure out how to change the color of the font if it adds up to be over budget. For Example:
=IF([Column]1 > [Column]2, "Red")
But by doing that, it doesn't change the color, it puts in the word Red.
Is there a way to do it in Conditional Formatting that I'm just missing?
Much appreciated!
Comments
-
I would recommend haveing a column that takes your budget value, subtracts the actual value spent and then you can use conditional formatting to colorize it based on if it's a negative value.
In the below Total (R) is the total requested or the budget and Total (A) is what was actually spent. This will return the difference of the two. If the Total (A) is more than the Total (R) it will return a negative value. You then just set a condition that if any value in that column is less than 0 it gets a red format.
=SUM([Total (R)]23 - [Total (A)]23)
The conditional will read something like
if Overunder is less than 0 then use this format (red text) on that column Overunder.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives