How can I make conditional formatting based on a positive or negative number?

I have "Budget," "Expenditure," and "Over/Under" columns. I already have a formula to calculate the "Over/Under" value. I want to have the value in that column show in RED font if it is over the "Budget" value (this will be different for each row). I tried in the conditional formatting section; however, the criteria only allows for a specific value and not the cell dependency.
Best Answer
-
Hello
If you have only text in the cell you can always set conditional formatting like: is less than or is greater than…
hope this helps.
The Real Smartsheet Enthusiast
Is there anything else we can help you with? - book your time!
MASA Consult - Your Aligned Smartsheet Partner
Find us on LinkedIn!
Answers
-
Hi @PRF,
I would suggest creating a helper column that would be set - like a checkbox that would be checked if you go over budget. You can then create a conditional format based on the checkbox.
Hope this helps.
Dave
-
Hello
If you have only text in the cell you can always set conditional formatting like: is less than or is greater than…
hope this helps.
The Real Smartsheet Enthusiast
Is there anything else we can help you with? - book your time!
MASA Consult - Your Aligned Smartsheet Partner
Find us on LinkedIn!
-
Yes @kowal, that did the trick. Thanks!
-
happy to help!
The Real Smartsheet Enthusiast
Is there anything else we can help you with? - book your time!
MASA Consult - Your Aligned Smartsheet Partner
Find us on LinkedIn!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives