Conditional Formatting or Formula
Good Day All:
I am trying to use Greater Than Conditional Formatting for two columns. However, Conditional Formatting does not allow you to select 2 columns. Perhaps, I have to use a formula?
Here is what I would like to do:
If % Complete (Planned) is Greater than % Complete (Actual), then Red
If % Complete (Planned) is Equal to % Complete (Actual), then Black
If % Complete (Planned) is Less than % Complete (Actual), then Green
Thanks
Comments
-
Try this one out. Make sure your column titles are accurate.
=IF([% Complete (planned)]1 > [% Complete (actual)]1, "Red", IF([% Complete (planned)]1 = [% Complete (actual)]1, "Black", IF([% Complete (planned)]1 < [% Complete (actual)]1, "Green")))
I designed it for row 1. Update the titles and row numbers as needed.
-
Excellent, Thanks!
-
You're welcome. Hope you got it working!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 458 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 137 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!